Sage 100

 View Only
Expand all | Collapse all

Object reference not set to an instance of an object Opening Excel

  • 1.  Object reference not set to an instance of an object Opening Excel

    Posted 10-30-2023 16:48

    I have two customers that reported the following error in Excel in the last hour:  An unexpected error occurred: Object reference not set to an instance of an object.  Apparently there was an Excel "auto update" that happened since last Friday because both customers reported it working then.  If the Sage Intelligence add-in is disabled then it works fine.  I tried modifying the Alchemex.ini file located on the local workstation client, adding ToggleCalcOffDuringRangeNaming=1 to the Excel Control section and it didn't help.  Any ideas?



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------


  • 2.  RE: Object reference not set to an instance of an object Opening Excel

    Posted 10-30-2023 16:50

    Sage is saying that if the Microsoft update 23.10 was installed then you need to rollback to 23.09 in order for Sage Intelligence to work.



    ------------------------------
    Dana Halpin
    Vrakas/Blum Computer Consulting, Inc.
    ------------------------------



  • 3.  RE: Object reference not set to an instance of an object Opening Excel

    Posted 10-30-2023 17:30

    Thank you @Dana Halpin !!   Your help is appreciated!



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 4.  RE: Object reference not set to an instance of an object Opening Excel

    Posted 10-31-2023 09:50

    I think this is an Excel issue, not SI. I had a client report this yesterday with the error resulting from opening Excel



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------



  • 5.  RE: Object reference not set to an instance of an object Opening Excel

    Posted 10-31-2023 09:53
    Edited by Beth Bowers 10-31-2023 09:54

    My Excel had the error upon opening this morning.  I have a client who reported the error went away if they disabled Power BI, so I wonder if something in SI is similar.  (I use SI but was not running an SI report when I got the error - I just opened Excel.)

    And I just Googled for how to set it back, because I'm NOT a network person, and found this, which did work.  Someone may have a quicker way.

    How Do I Rollback an Office Version? | Designer for Microsoft Office | Windward Documentation (windwardstudios.com)

    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 6.  RE: Object reference not set to an instance of an object Opening Excel

    Posted 10-31-2023 10:20

    Sage engineering is working on a hotfix for this. It has to do with the Microsoft Office update 2310 last week. It's not compatible with Sage Intelligence.



    ------------------------------
    Dana Halpin
    Vrakas/Blum Computer Consulting, Inc.
    ------------------------------



  • 7.  RE: Object reference not set to an instance of an object Opening Excel

    Posted 10-31-2023 16:11

    Any idea when this Sage patch will be released?

     

     

     

    Please use the link below if you would like to book an appointment with me.

    DSDInc@dsdinc.com/bookings/">Book with Mary

     

     

    Mary MaysSr. Consultant

     

    Wichita: 316.269.4264 | DSD Corporate: 800.627.9032

    e: marymays@dsdinc.com

    w: dsdinc.com

     

    Sage 100 Support:       Sage100support@dsdinc.com

     

     






  • 8.  RE: Object reference not set to an instance of an object Opening Excel

    Posted 10-31-2023 17:23

    Solution ID:  231030223256853 does not indicate a hotfix is being developed. 

    This is going to affect everyone whether they use SI or not. 

    Did anyone just try disabling the add-ins if the user doesn't use SI? 

    Mine has not updated yet, so I caught it and disabled updates. 



    ------------------------------
    Eric Lunceford
    First Mate Business Solutions
    Oklahoma City, OK
    877-880-8960
    ------------------------------



  • 9.  RE: Object reference not set to an instance of an object Opening Excel

    Posted 10-31-2023 17:47
    Edited by Eric Lunceford 10-31-2023 17:57

    Microsoft just released Build 16924.20124. 

    That was not there 30 minutes ago! 

    That build fixes the issue. 

    ------------------------------
    Eric Lunceford
    First Mate Business Solutions
    Oklahoma City, OK
    877-880-8960
    ------------------------------



  • 10.  RE: Object reference not set to an instance of an object Opening Excel

    Posted 10-31-2023 18:08

    tHANKS @Eric Lunceford (Skipper).  Very timely post



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------



  • 11.  RE: Object reference not set to an instance of an object Opening Excel

    Posted 10-31-2023 18:17

    Must have been a hot one.

    Excel Error: object reference not set to an instance of an object - Microsoft Community Hub



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------



  • 12.  RE: Object reference not set to an instance of an object Opening Excel

    Posted 10-31-2023 18:39

    @Eric Lunceford  can you confirm that the new MS Build 16924.20124 resolves the issue?



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 13.  RE: Object reference not set to an instance of an object Opening Excel

    Posted 11-01-2023 09:45

    @Doug Higgs, Yes, after the new update was released, I turned updates back on and updated now. It took me to the bad build and I received the error after it was installed and Excel opened back up. I updated now again and got the good update and no error. 



    ------------------------------
    Eric Lunceford
    First Mate Business Solutions
    Oklahoma City, OK
    877-880-8960
    ------------------------------



  • 14.  RE: Object reference not set to an instance of an object Opening Excel

    Posted 11-01-2023 09:49

    That's awesome.  So it seems that if the end user does nothing and either allows an auto update or forces the new update then all is well.  Thanks @Eric Lunceford  !



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 15.  RE: Object reference not set to an instance of an object Opening Excel

    Posted 11-01-2023 16:01

    Let sleeping dogs sleep



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------