Yesterday I spent several hours updating the VBA code in an excel spreadsheet. Today I go to open it and it won't open. It just says that "Excel is trying to recover my information" and "A problem caused excel to stop working correctly".
So I guess this means that it's corrupted beyond repair.
This happens to everyone at my office every few days on average. I'm not sure if anyone has an idea what can be done to prevent worksheets from getting corrupted. Or what exactly causes it.
Anyway, is there any way to get into the VBA code to copy the changes I made and put them in an uncorrupted worksheet? Currently it won't even open, but the data has to be accessible somehow right?
Bookmarks