Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Healing/recompiling corrupted Excel files?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Healing/recompiling corrupted Excel files?
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Healing/recompiling corrupted Excel files?
Well I found out what was casuing the corruption problems and loss of
pivot tables.....MICROSOFT!!! A certified BUG! read he "Unable to read file" error message when you open Excel file that contains a PivotTable report http://support.microsoft.com/default...b;en-us;819853 Ace70 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Corrupted Excel Files | Excel Discussion (Misc queries) | |||
Wat caused my excel file to get corrupted | Excel Discussion (Misc queries) | |||
my excel files have got corrupted | Excel Discussion (Misc queries) | |||
Corrupted Excel file - but on only one machine? | Excel Discussion (Misc queries) | |||
unable to reopen saved files message says corrupted | Excel Discussion (Misc queries) |