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...
Cannot Define field more than once
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...
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...
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.
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
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?
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),"")
So I have this...
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 & _...
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...
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...
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...
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...