Forum Discussion
Excel Error: object reference not set to an instance of an object
- Oct 23, 2023
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.
I, too am having this issue with Sage 100 and one user. Disabling the add-in clears the error but I can't run Intelligence Reports. Reinstalling Sage and Office didn't help
- Carnegie5930Oct 31, 2023Copper Contributor
colorflakes 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
- LisasmithsnyderNov 02, 2023Copper Contributor
Carnegie5930 Thank you! This update process worked for me (I also use Sage 100)
- cradikOct 31, 2023Copper ContributorThis worked for me and our team. We appreciate this!
- Carnegie5930Oct 31, 2023Copper ContributorI 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
- Nick_MilesOct 31, 2023Copper Contributor
Worked perfectly thank you Carnegie5930!
- Carnegie5930Oct 31, 2023Copper Contributor
Nick_Miles great to hear!
- Taylor-FFSOct 31, 2023Copper Contributor
Carnegie5930 This unfortunately did not work for me. Has anyone else figured out a solution to this? I am starting to see this pop up for more users as office 365 updates I assume.
- radartcOct 31, 2023Copper ContributorRolling back to version 2308 worked for us.
Also, anyone who needs to run Financial Reporting can't just remove those add-ins as they are needed for that.
- HansVogelaarOct 31, 2023MVP
Good to hear that. Thanks for the heads-up.