I've got a complex spreadsheet with >25 tabs, vba code behind all + modules, named ranges and tables. I recently did an update for my users, but they are experiencing computer freeze-up or BSOD on trying to save the file (saving through code).
Wanting to debug the problem, I tried the suggestion to open the file with Open & Repair, and indeed it did note there were errors, but clicking the HTML link in the error box didn't really say anything about a specific error. I then tried the Open & Repair on a newly created, blank, spreadsheet and got the exact same error message, save for the name of the spreadsheet. I can't recreate the crashes on my machine and everything works fine. The users are mostly using Excel 2007, and I'm developing on 2010 and 2013, but I believe the XLSM file structure is probably the same.
Please help.
Wanting to debug the problem, I tried the suggestion to open the file with Open & Repair, and indeed it did note there were errors, but clicking the HTML link in the error box didn't really say anything about a specific error. I then tried the Open & Repair on a newly created, blank, spreadsheet and got the exact same error message, save for the name of the spreadsheet. I can't recreate the crashes on my machine and everything works fine. The users are mostly using Excel 2007, and I'm developing on 2010 and 2013, but I believe the XLSM file structure is probably the same.
Please help.