Microsoft 365 build 2206 issue with XLSM files containing Excel 4 macros

Copper Contributor

I have a number of personal spreadsheets that I have built over the years using Excel 4 macros (shows how long ago I learnt Excel!) to work on subjects including power consumption analysis. These have worked fine on many Excel versions in the past, and more recently Microsoft 365 up to build 2205. Having just updated to 2206, when I open a spreadsheet I get a "We found a problem with some content ... Do you want us to try to recover..." message, and on clicking Yes it attempts but fails to open. How can I resolve this issue?

0 Replies