Every now and then, for no apparent reason, when we try and save an Excel file that has been used for a awhile, we are told that the file can’t be saved as it is corrupt and Excel will try and repair it. If you eventually are forced to repair the file and save as a new version, it is useful to know what is lost when repairing a corrupt Excel file.
With luck all the data and formulas will stay (not a guarantee re the formula). If you don’t have a recent enough version, you may need to save the repaired file (as a new name) and then open both and (unfortunately) manually work through and redo some of the ‘lost in repair’ features.
Repaired Excel file changes
The following items are removed. Note that this is not comprehensive and not all of these will happen every time.
Potentially Serious ‘Repairs’
- External links especially if it is part of a formula e.g. external link x 1.15 (effectively it becomes a paste as values),
- Charts/ graphs,
- External connections e.g. links to a website or PowerQuery links,
- Data Validation settings (drop down lists disappear),
- Conditional formatting (warning cells may not give you any warning any more).
Repairs worth noting
- Comments/ notes,
- Column widths are reset,
- Freeze panes settings,
Other things to look for
Based on the above, it seems that besides what is IN a cell, anything ON a cell is susceptible to ‘repairs’. So numbers, text and most formula would stay, but anything on the cell (data validation, conditional formatting, notes) is removed.
So think through all the little extra features that you add on. These are likely to be affected. Some are just display type issues and not as serious, but some may remove controls or stop warnings being issued.