You might start with Rob Bovey's Code Cleaner:
http://www.appspro.com/Utilities/CodeCleaner.htm

It might not solve all your problems, but it won't hurt to try.

HTH,


"Ace70" wrote in message
oups.com...
Hi

I have an Excel file that I suspect has some element of corruption
associated with the file. It basically a data processor I have been
developing intended for general use that accepts in data and
manipulates it with prodigious use of formulas, pivot tables, macros
and conditional formating. There is no precious "data" as such stored
in it, but rather hours of for effort making it "engine" which does
lot of things with the data.

I have noticed very starnge things lately (inability to view and edit
comments, the drop down menus on validated cells copied from one place
to another randomly not working, Excel crashes etc). I just
expereiced my first major error message (while trying to hide columns)
that told me that the file was corrupted and that both pivots tables
were lost when Excel recovered and "repaired" the file for me. The
pivot tables still "look" like they are there in the spreadsheet but
Excel doesn't reconginze them anymore than just normally formatted
cells.

As my pivot tables are key to the spreadsheet and nestled within in, I
can see it would be a laborious job trying to recreate them new then
restablishing the formula references to the. Luckily I have backups
files of earlier stages of development of this file with all the key
pivot tables working as they should . However, I strongly suspect
they too are "infected" with some corrupted code that way ultimately
result in the same fate as the original file shoudl I decide to use
these backups as a basis for further development.

Is there a way to "recompile" (with error checking and correcting) the
Excel file in a way that is not aimed at just salvaging dumb rows and
rows for numbers/data (which is probably good for many users even if
athey lose all the formatting and pivot tables etc), but actaully aims
to preserve formulas/controls/functionality of the file? Basically,
is there a proven/recmmended way to check and restore the integrity
and functionality of an Excel file rather than being focused on data
recovery?

Cheers

Ace70