Quote: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.
Whats New
Updates: official site does not provide any info about changes in this version.