Excel File Remediation Tool 2.0.132

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.



What's New

Updates: official site does not provide any info about changes in this version.

HOMEPAGE

https://jkp-ads.com/ProductsRemediation.asp