1. D

    We found a problem with some content in "File name". Excel annoying message

    Hello everybody, Whenever I open my excel sheet I get the following message: "We found a problem with some content in "File name xxx". Do you want us to try to recover as much as we can? If you trust the source of this workbook, click yes" It is super annoying. It started happening after I...
  2. S

    Annoying Error When Trying to Reload Excel Database

    Cannot Define field more than once and The specification failed to execute. Try re-creating the specification I am simply trying to reload an excel file with the updated one, I've done it before no errors. I even removed the Auto Numbered ID and reran the load, same issue. if not this error...
  3. P

    delete rows not containing specific start with multiple criteria

    Hi experts! I have a problem with trying to write a VBA code...have tried creating & looked around the web and have so far failed miserably with this. I am trying delete rows NOT starting with three letters - specifically HKG, BJS and SYD. The table looks like the below with the data being in...
  4. K

    Excel 2010 vs Excel 2016 (365)

    Hi My formulas, especially the more complex ones, works in my Excel 2010 at home but gives an error message in 2016 at work!? Even when copied and pasted from 2010 to 2016. Annoying! Any help will be much appreciated.
  5. tobyz95

    Dotted Line Around Cell

    Hi ALL, I have Excel 2016 and am wondering why I have a dotted line around cell after copy, paste and save. It is annoying. Is there a setting? Thanks for any help!
  6. E

    **NEED HELP** with error messege

    i sell on amazon and when i want to upload by catalog in bulk amazon provides this flat file. when i open it, it asks to either enable or disable macros. if i click either or once i wanna save that file i get this annoying message that says Microsoft Visual Basics does anyone know what to do here
  7. S

    Back arrow (Undo) is greyed out after running any script

    Whenever I test a macro, (with what is normally a non-successful result) I cannot Undo the operation by clicking the Undo arrow to go back, I have to close the file and start over with a fresh copy. Hugely annoying...Anyone know why?
  8. Z

    Formula ?

    Hi I actually need help on both of these. I just need to return blank if nothing is found. Right now it returns 0 if nothing is found and is kind of annoying thanks =' Rates Table'!A68 =IFERROR(VLOOKUP($A$6:$A$208,' Rates Table'!$A$1:$D$506,4,0),"")
  9. M

    Categorized graph with months

    Hi, Does anyone know how to achieve this kind of graph? (assuming the x's are numbers of course) Thanks, Mike
  10. D

    Really annoying...

    So I have this... Sub SaveMyWorkbook() Dim strPath As String Dim strFolderPath As String strFolderPath = "S:\Quality Control\Reports\Defects\2017\" strPath = strFolderPath & _ Sheet2.Range("A1").Value & _ Sheet2.Range("A2").Value & _...
  11. C

    Need assistance with workbook for work

    Hi guys, not sure if anyone can help me but im having trouble making an excel spreadsheet for work to calculate quotes faster. Hopefully you'll understand what I mean;) Okay so basically im trying to speed up the quote process at work by making a spreadsheet to calculate the sizes of boxes...
  12. B

    Excel cannot complete this task with available resources. Annoying Bug! HELP!!

    I have Excel 2010, and I've never had that kind of issues in previous Excel versions. It doesn't matter the size of the file, if I use macros or not, this message appears if I want to create a new tab... or open a file, this message appears, forcing me to close everything, and open again, which...
  13. O

    Any way to change the annoying way comboboxes behave?

    Hi All, You know with comboboxes on userforms... when you click on the arrow to show the dropdown list... if you move to the list too quickly (seems to be before the shadow has appeared under the list) then the list disappears and whatever your mouse happens to be hovering over is selected...
  14. M

    Excel 2010 Pivot table field list

    Good Morning Mr. Excel message board, I am having a very difficult time creating a pivot table in excel 2010 to track some of my expenses. The problem is that the field lists are not showing up like they used to in 2007. I have clicked show field list, but no matter what I try they will not...

Some videos you may like

This Week's Hot Topics

  • Use Filter function with 2 criteria to return a specific value
    I've spent many hours trying to find out why the basic formula for Filter function with 2 criteria will not return a value other than #CALC. I'm...
  • Loop stopping at row 10
    Below is a code I had a lot of help with from user such as yourself. This code worked well but now is stopping a row 10 and I can't see why! Could...
  • Numerical Order Code for Macro
    I am trying to find a code or fix what i have on the macro that will automatically make the certain column generate in numerical order when I...
  • Calculate time in excel
    I get a text report from our time keeping system that i dump into excel through a data connection and I need to calculate the total hours for a...
  • VBA
    Hello everyone, I need your help please. I just need VBA code to get my reports working. What I want to do is whenever these dropdowns are...
  • Help with formula to sum numbers prior to date
    Hello, I was hoping to get some assistance as I'm having trouble with this. Using my table below as an example, how could I write a formula which...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back