Damage to the file was so extensive that repairs were not possible

[Guest]

I'm using Excel 2002 to edit a spreadsheet with 11,400 rows and 17 columns -
certainly with the size limitations of Excel. I have about 15 macros defined
for this spreadsheet that, up until recently, were working just fine. I
added another set of macros (5) to the existing list of macros and tested
each one successfully. I saved the spreadsheet, content with the solution I
created. But when I try to reopen the spreadsheet I get the following error
message:
"Damage to the file was so extensive that repairs were not possible. Excel
attempted to recover your formulas and values, but some data may have been
lost or corrupted."
Well, no kidding! All of the formatting is gone and, worse still, all of
the macros were removed. What gives? Is there a limit to the number of
macros one can define in Excel?

 

[Nick Hodge]

Bill

Not per se, but macro code builds up hidden 'rubbish' when being recorded
and edited which can cause workbook corruption. There are of course many
other reasons for corruption also, hence the need for a back-up strategy on
important files.

Rob Bovey's code cleaner will assist for future projects.

http://www.appspro.com/Utilities/CodeCleaner.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)