73. Excel Tips - Fix Corrupt Spreadsheet
Today's tip is one of the most useful tips I will ever write.
- My spreadsheet is behaving oddly, what can I do ?
Most likely, your spreadsheet is corrupt, and needs to be cleaned. Corrupt spreadsheets are very common, and happen over the course of time through significant changes and file saves. Excel gets it's knickers in a twist after a while, and needs to go back to square 1. As standard practise if I am developing a large spreadsheet system, I will clean them on a regular basis. Cleaning a spreadsheet is essentially creating a new one, and copying everything across.
Here are the steps that you need to follow to uncorrupt your spreadsheet:
- Take a copy of your spreadsheet in case you mess up.
- Save file
- File (or office button) => SaveAs
- Give it a new name.
- Insert a new worksheet in the corrupt workbook.
- Select all the worksheets apart from the one you just added.
- Create a new workbook.
- Unmaximise the workbook windows.
- Drag all the worksheets across to the new workbook.
- Drag all the code modules across to the new workbook.
- Copy all the sheet code across to the new workbook.
- Add any references the old workbook had to the new workbook.
- Close the old workbook, and DON'T SAVE THE CHANGES.
- Save the new workbook with a new name
- Compare to the old one to make sure everything still works.
Training Video on how to Fix Corrupt Spreadsheet in Excel: