Forum Discussion

blairwhitworth320's avatar
blairwhitworth320
Copper Contributor
Oct 23, 2023
Solved

Excel Error: object reference not set to an instance of an object

Hi- In the last week I've started receiving the following message whenever I open Excel 365 (through the application, or opening a file):  I tried using the short and long repair options for ...
excel
colorflakes's avatar
colorflakes
Copper Contributor
Oct 30, 2023

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

 

Carnegie5930's avatar
Carnegie5930
Copper Contributor
Oct 31, 2023
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
  • Taylor-FFS's avatar
    Taylor-FFS
    Copper Contributor
    Oct 31, 2023

    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. 

    • radartc's avatar
      radartc
      Copper Contributor
      Oct 31, 2023
      Rolling 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.
      • LindaZ2140's avatar
        LindaZ2140
        Copper Contributor
        Nov 01, 2023

        radartc 

        How do you rollback the Microsoft update?  Our IT person said you can no longer rollback the updates.  One of our computers is still on the 2309 version and is working fine.  It was 2310 that caused the conflicts with Sage/Excel.  Besides getting the Excel error every time, I can no longer export financials from Sage to Excel.

Resources