Forum Discussion
Excel Macros disappear from xlsm file
Hi, since a few days we are experiencing the following on several computers (we are O365 customers and Excel is always update automatically (Version 2311 build 17029.20068) with Excel: We are...
I did have problems many times since December, I kept good copies and restored all the time.
However on 5.Jan.24 I updated my Excel to Microsoft® Excel® for Microsoft 365 MSO (Version 2312 Build 16.0.17126.20132) 32-bit, since then my Macro enabled Excel files has been run without problem. I use task schedule and script to auto run macro on excel files 18 times per day, I haven't seen any errors. Maybe my macro is rather simple comparing to yours, mine only refresh Data Connection and save.
Since we know Version 2311 is the problematic one, maybe you should make sure everyone update their Excel to 2312?
However on 5.Jan.24 I updated my Excel to Microsoft® Excel® for Microsoft 365 MSO (Version 2312 Build 16.0.17126.20132) 32-bit, since then my Macro enabled Excel files has been run without problem. I use task schedule and script to auto run macro on excel files 18 times per day, I haven't seen any errors. Maybe my macro is rather simple comparing to yours, mine only refresh Data Connection and save.
Since we know Version 2311 is the problematic one, maybe you should make sure everyone update their Excel to 2312?
JazzTea This is also what I did, I used to have 365 MSO runing in 64 bit version until 14 December 2023 when al my xlsm sheets encountered problems with VBA. What i did is reinstall MSO 365 in the 32 bit version (Microsoft® Excel® for Microsoft 365 MSO (Version 2402 Build 16.0.17318.20000) 32-bit) and now all works again.
As my excel sheets daily collect data from the web and store it I can see that from 13/14 December 2023 something went wrong.