Many companies have been using spreadsheets for decades. Sometimes spreadsheet models may go back as much as 20 years, when the first steps were taken to build them, sometimes using Lotus 123 or other spreadsheet applications.
More often than not, these (often business critical) models have been extended considerably over the years Sheets have been inserted, or copied over from other workbooks Formatting has been changed hundreds of times to thousands of cells Defined names (named ranges) have been inserted. Knowingly or inadvertently (e.g. by copying worksheets) Corrupt defined names have remained from merge from other spreadsheet file formats to Excel User defined functions in VBA
My customer (who had already been in contact with Microsoft premium support about these issues without getting resolutions) asked me whether it would be possible to build a wizard-like tool to salvage this kind of files. Even better: to remove possible corruptions entirely, without damaging the integrity of the spreadsheet model, without removing formatting and also making sure any VBA code is retained.
Screen :
What's New
Updates: official site does not provide any info about changes in this version.