ERROR - Object reference not set to an instance of an object - What is this???

elvele0

New Member
Joined
Jul 25, 2014
Messages
3
I receive this error message in Excel at lease 4-5 times a day while opening a spreadsheet. I am not doing anything special, no macros, no large workbooks, and nothing that contains advanced formulas. I just click on a regular xls or xlsx doc and I get this error message and a blank page. When I close it and reopen the file, it works fine. I haven't been able to find anything online that would help make this go away, even our IT dept is stumped. Anyone have this problem, or know how to fix it? I am running 64 bit version of excel in Windows 7. There is a screen shot in the link below:

eldtoj.png
[/IMG]
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

starl

Administrator
Joined
Aug 16, 2002
Messages
5,969
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
  2. MacOS
well, you appear to have several addins installed. One of those is generating the error probably.
When you get the error, do you have a workbook open? even the blank default one?
Since it's coming from an addin, unless you can turn off its error handling and unprotect the code, not much we can do.
I'm guessing that the addin doesn't like it when you don't have a workbook open. What I mean is:
1. Open Excel
2. You get a blank workbook
3. Close the blank workbook - Excel is still open
4. Do you get the error message then?
5. or you then open a workbook (after step 3) and get the error?
 

Watch MrExcel Video

Forum statistics

Threads
1,122,961
Messages
5,599,061
Members
414,281
Latest member
Engjamal2021

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 MrExcel.com.
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 "mrexcel.com".
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
Top