Forum Discussion
Repairing a damaged file
Hi Guys, I have a peculiar issue with an *.xlsm file that I created in Excel 365. The file opens fine. The data seems to be intact. My charts are working and responding to their associated slicer...
Try using VBA Code Cleaner: http://appspro.com/Utilities/CodeCleaner.htm If you are not allowed to install software, this might help too:
- Save-as your file to xlsx
- close and re-open both the xlsx and the xlsb
- In the VBA project explorer drag all modules, userforms and class modules from the xlsb to the xlsx
- Copy all code from sheet modules and ThisWorkbook module to the appropriate objects in the xlsx
- Save-as the xlsx to xlsm or xlsb
- close and reopen the newly saved file and see if it behaves itself.
- Save-as your file to xlsx
- close and re-open both the xlsx and the xlsb
- In the VBA project explorer drag all modules, userforms and class modules from the xlsb to the xlsx
- Copy all code from sheet modules and ThisWorkbook module to the appropriate objects in the xlsx
- Save-as the xlsx to xlsm or xlsb
- close and reopen the newly saved file and see if it behaves itself.