xlsm file not working (lags, no response); won't convert; MS support can't help, referred me here

%3CLINGO-SUB%20id%3D%22lingo-sub-1641406%22%20slang%3D%22en-US%22%3Exlsm%20file%20not%20working%20(lags%2C%20no%20response)%3B%20won't%20convert%3B%20MS%20support%20can't%20help%2C%20referred%20me%20here%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1641406%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20working%20on%20this%20xlsm%20file.%20All%20of%20a%20sudden%20it%20wasn't%20responding%20anymore%20and%20kept%20using%20around%20100%25%20of%20CPU%20resources.%20I%20can't%20even%20scroll%20around%20anymore%20without%20the%20file%20glitching.%20It%20doesn't%20make%20a%20difference%20if%20I%20choose%20to%20disable%20or%20enable%20macros%20upon%20opening%20the%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20some%20of%20my%20own%20troubleshooting%2C%20I%20contacted%20MS%20support.%20This%20is%20what%20we%20tried%3A%3C%2FP%3E%3CP%3E-%20We%20reinstalled%20Excel%20%E2%80%93%20didn't%20work%3B%3C%2FP%3E%3CP%3E-%20We%20tried%20to%20convert%20the%20file%20('save%20as')%20xlsx%20%E2%80%93%20didn't%20work%3B%3C%2FP%3E%3CP%3E-%20We%20tried%20to%20convert%20to%20xls%2C%20that%20worked%20but%20the%20new%20file%20was%20behaving%20the%20same%20(bad)%20way.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20support%20assistant%20referred%20me%20to%20MS%20Tech%20Community%20(here).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20thing%20I%20tried%20before%20posting%20here%20is%20getting%20rid%20of%20the%20macros%20(which%20I%20don't%20need%20anymore).%20I%20would%20like%20to%20keep%20the%20formatting%20intact%20since%20that's%20part%20of%20the%20work%20I%20have%20been%20doing%20in%20my%20file%2C%20so%20csv%20is%20not%20an%20option.%20However%2C%20that%20didn't%20allow%20me%20convert%20the%20file%20either.%20I%20need%20help.%20Thanks%20a%20million%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eerror%20message%20when%20trying%20to%20save%20as%20.xlsx%3A%3C%2FP%3E%3CP%20class%3D%22p1%22%3E%22Errors%20were%20detected%20while%20saving%20%E2%80%99%2Fpath%2Fto%2Flocation%2Fof%2Ffile.xlsx%E2%80%99.%20Microsoft%20Excel%20may%20be%20able%20to%20save%20the%20file%20by%20removing%20or%20repairing%20some%20features.%20To%20make%20the%20repairs%20in%20a%20new%20file%2C%20click%20Continue.%20To%20cancel%20saving%20the%20file%2C%20click%20Cancel.%22%3C%2FP%3E%3CP%20class%3D%22p1%22%3E--%26gt%3B%20Needless%20to%20say%3A%20Excel%20was%20not%20able%20to%20save%20the%20file.%3C%2FP%3E%3CP%20class%3D%22p1%22%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMacOS%20Catalina%2010.15.6%3C%2FP%3E%3CP%3EExcel%2016.40%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1641406%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Frequent Visitor

Hi,

 

I have been working on this xlsm file. All of a sudden it wasn't responding anymore and kept using around 100% of CPU resources. I can't even scroll around anymore without the file glitching. It doesn't make a difference if I choose to disable or enable macros upon opening the file.

 

After some of my own troubleshooting, I contacted MS support. This is what we tried:

- We reinstalled Excel – didn't work;

- We tried to convert the file ('save as') xlsx – didn't work;

- We tried to convert to xls, that worked but the new file was behaving the same (bad) way.

 

The support assistant referred me to MS Tech Community (here).

 

The thing I tried before posting here is getting rid of the macros (which I don't need anymore). I would like to keep the formatting intact since that's part of the work I have been doing in my file, so csv is not an option. However, that didn't allow me convert the file either. I need help. Thanks a million in advance.

 

error message when trying to save as .xlsx:

"Errors were detected while saving ’/path/to/location/of/file.xlsx’. Microsoft Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving the file, click Cancel."

--> Needless to say: Excel was not able to save the file.

 

MacOS Catalina 10.15.6

Excel 16.40

0 Replies