Forum Discussion

Copper Contributor

Dec 14, 2023

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...

excel

Macros and VBA

Joost_van_Andel

Copper Contributor

Feb 05, 2024

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.

PeterNagy

Copper Contributor

Feb 17, 2024

Joost_van_Andel

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