Forum Discussion
Excel Macros disappear from xlsm file
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.
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..
PeterHello PeterNagy and all!
I just updated all our 64-bit Excel copies to the 4-March-2024 Version 2402 (Build 17328.20162), and we kept the AccessibiltyCPLAdmin tool checked. (Prior to that, only the 2307 version from 26-July seemed to work for us.)
Might be a little early to celebrate, but for the past week, we have had 0 file issues. I think our macro file "gremlin" has finally been exorcised.
Wishing you all the same good luck!
- 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?
