Forum Discussion
Excel Error: object reference not set to an instance of an object
The problem could be cause by a file that is automatically loaded when you start Excel, such as the personal macro workbook PERSONAL.XLSB or an add-in. Follow the steps described in Excel not responding, hangs, freezes or stops working to check which one of these it is.
Completely quit Excel.
Then hold down the left Ctrl key while you start Excel.
Excel will ask whether you want to start Excel in safe mode. Answer Yes.
Does the problem still occur?
HansVogelaar I use Office 365 and Sage 100. I opened Excel, went to Account and updated my license. After that I went to Update Options and selected Update Now. That has resolved the Excel Error: object reference not set to an instance of an object
- Thanks - this worked for me too
The problem could be cause by a file that is automatically loaded when you start Excel, such as the personal macro workbook PERSONAL.XLSB or an add-in. Follow the steps described in Excel not responding, hangs, freezes or stops working to check which one of these it is.
The tool pointed me to a COM add-in as the source of the problem. I'm not sure the origin of these applications but I inactivated Report Designer and that seems to have worked. Thanks for your help!
