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...
We started having this problem last month (Dec. 2023). We are running Office 365 Ver 2312 (Build 17126.2032 Click-to-run). A couple of employees that use the same file are on the previous version 2311.
A spreadsheet that we have been using for 3 years suddenly loses all the VBA code or throws the error "Damage to the file was so extensive that repairs were not possible. Excel attempted to save your formulas and values, but some data may have been lost or corrupted."
Our only solution right now is to back up very frequently and to store all the macros in exported .cls files so that they can be re-imported.
We have had to re-build this file 3 times now. It is very time consuming and painful. Please Microsoft - roll back to a version that works.
A spreadsheet that we have been using for 3 years suddenly loses all the VBA code or throws the error "Damage to the file was so extensive that repairs were not possible. Excel attempted to save your formulas and values, but some data may have been lost or corrupted."
Our only solution right now is to back up very frequently and to store all the macros in exported .cls files so that they can be re-imported.
We have had to re-build this file 3 times now. It is very time consuming and painful. Please Microsoft - roll back to a version that works.
dgoeldner Same issue here since 14 december 2023 my excel sheet .xlsm stopped working with ActiveX buttons on my sheet. Insofar I have found no solution how to recover or repair the file. I'm in doubt if it is a Windows 11 issue or an Excel 365 (Beta channel) issue. Also since 14 december my Excel seems less sable than before. Reinstalling did not resolve my problem.