Forum Discussion
Excel Macros disappear from xlsm file
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.
Hi, I have made the very same experience. As long as the 32 bit version was installed everything was fine (although I have to admit I installed by chance the 32 version not on purpose). I just tried to reinstall the 64 bit version 2 days ago and right on the 2nd they I have my first break down again.
So Microsoft try to dig deeper in the 64 bit version as something is not OK!!!!
Cheers
Peter
Joost_van_Andel Hi I am glad to know that your Macro enabled Excel runs ok now. I have just noticed that on Microsoft Release notes, they did admit Excel Macro corruption problem. https://learn.microsoft.com/en-us/officeupdates/current-channel?redirectSourcePath=%252farticle%252f95c8d81d-08ba-42c1-914f-bca4603e1426
Version 2401: February 13
Version 2401 (Build 17231.20236)Excel
We fixed an issue where macros were being corrupted when saving Excel files.I hope this would fix Macro problem once and forever.
For us the Update 2401 did not fix the issue. We are using the 64bit version. So that means the "bugfix" in version 2401 is only working with 32bit?
Someone here tried the 2402 version? Maybe its working there with 64bit?
Thank you guys!- Hi,
we still had issues under 2402, but last week (based on an earlier comment in this forum) we have added in the VBAProject - References the AccessbilityCplAdmin 1.0 Type Library and since then we have no crush... but this is just a simple experince and we do not know what this library is for..
Peter
- HI,
we have this version running (17231.20236) but unfortunatelly we are still experiencing the problem. So I will return to the 32 bit version.... this is really annoying.- I just have reinstalled the 32 bit version, and the file which was not running (10 minutes earlier under 64bit) runs fine again without any change. Why on earth?
- how do i do that?
- Easy:
Completely deinstall MSO 365 (64 bit) with uninstall support tool from microsoft: (option 2)
https://support.microsoft.com/en-gb/office/uninstall-office-from-a-pc-9dd49b83-264a-477a-8fcc-2fdf5dbf61d8
Than login to your Microsoft Account and reinstall MSO 365 (32 bit), be sure not to choose the default option but specific select the 32 bit version .
For me that worked excel is collecting data from the web on a daily basis, and VBA is stable incuding my buttons on the sheets.
Current stable version: Microsoft 365 MSO (Version 2402 Build 16.0.17318.20000) 32-bit
