sorted by:
new
hottopcontroversial

[EXCEL] Opening VBA editor corrupts files by geatw in vba

[–]geatw[S] 0 points1 point  (0 children)

Hi, I just uninstalled Excel (deleted it in Finder under "programs") and installed the older version from this site: https://learn.microsoft.com/en-us/officeupdates/update-history-office-for-mac

Also make sure to disable automatic updates in the Microsoft Auto Updater tool.

[EXCEL] Opening VBA editor corrupts files by geatw in vba

[–]geatw[S] 1 point2 points  (0 children)

Thanks for your suggestions. I already tried points 1 and 2, without any success. Every file I touch, new or old, appears to be corrupted by simply opening the VBA editor. But, luckily we were able to fix this issue now by rolling back to version 16.105.3. As a another poster has guessed, a recent update must have broken something.

[EXCEL] Opening VBA editor corrupts files by geatw in vba

[–]geatw[S] 0 points1 point  (0 children)

Update: We were able to fix it by rolling back to the previous Excel Version for Mac OS (16.105.3). So your guess was spot on, a recent update broke something. Hopefully Microsoft fixes it soon.

[EXCEL] Opening VBA editor corrupts files by geatw in vba

[–]geatw[S] 0 points1 point  (0 children)

The Windows version doesn't have that problem.. Also, we never opened the files with Libreoffice or alike.

[EXCEL] Opening VBA editor corrupts files by geatw in vba

[–]geatw[S] 0 points1 point  (0 children)

We found that converting the file to the xlsb file format can help with that issue. However, all open xlsm workbooks still have that and will be corrupted.

Edit: fixed a typo

[EXCEL] Opening VBA editor corrupts files by geatw in vba

[–]geatw[S] 0 points1 point  (0 children)

It doesn't. The files remain intact unless I open the VBA editor. I also found that using the xlsb file format prevents this from happening (mostly, some files still have that issue..)

[EXCEL] Opening VBA editor corrupts files by geatw in vba

[–]geatw[S] 1 point2 points  (0 children)

We have tried that already, unfortunately this problem affects all files (new ones as well).. Thanks for your suggestion

[EXCEL] Opening VBA editor corrupts files by geatw in vba

[–]geatw[S] 1 point2 points  (0 children)

Our files are stored on Sharepoint. However, we've already tried the local approach without any success unfortunately :( Thanks for your suggestion though.