Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table report discarded in Excel 2003 - any fix available?
When I open an Excel workbook in Excel 2003, I occasionally get the message:
"Errors were detected in file 'path\Accounts.xls' "The following is a list of repairs: "PivotTable report 'PivotTable1' on '[Accounts.xls]Analysis ex VAT' was discarded due to integrity problems.W" I note there appears to be a fix for Excel XP (SP3) but I can't find a solution for Excel 2003. This problem did not occur with Excel 2000. A solution for Excel XP was to turn off auto-recover, but I don't want to do that. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table report discarded in Excel 2003 - any fix available?
I don't understand how auto-recovery would affect your problem (I'd suspect a
coincidence if I were a betting person). But it sounds like the workbook is corrupted to me. Lots of people have praised OpenOffice.org for saving their data and code. http://www.openoffice.org, a 60-65 meg download or a CD There are commercial recovery services. I've never used it, but you might want to check into: http://www.officerecovery.com Desperate Don wrote: When I open an Excel workbook in Excel 2003, I occasionally get the message: "Errors were detected in file 'path\Accounts.xls' "The following is a list of repairs: "PivotTable report 'PivotTable1' on '[Accounts.xls]Analysis ex VAT' was discarded due to integrity problems.W" I note there appears to be a fix for Excel XP (SP3) but I can't find a solution for Excel 2003. This problem did not occur with Excel 2000. A solution for Excel XP was to turn off auto-recover, but I don't want to do that. Any ideas? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table report discarded in Excel 2003 - any fix available
"Dave Peterson" wrote: I don't understand how auto-recovery would affect your problem (I'd suspect a coincidence if I were a betting person). But it sounds like the workbook is corrupted to me. Lots of people have praised OpenOffice.org for saving their data and code. http://www.openoffice.org, a 60-65 meg download or a CD There are commercial recovery services. I've never used it, but you might want to check into: http://www.officerecovery.com Desperate Don wrote: When I open an Excel workbook in Excel 2003, I occasionally get the message: "Errors were detected in file 'path\Accounts.xls' "The following is a list of repairs: "PivotTable report 'PivotTable1' on '[Accounts.xls]Analysis ex VAT' was discarded due to integrity problems.W" I note there appears to be a fix for Excel XP (SP3) but I can't find a solution for Excel 2003. This problem did not occur with Excel 2000. A solution for Excel XP was to turn off auto-recover, but I don't want to do that. Any ideas? -- Dave Peterson Thanks for reply. I can recover the Pivot Table by re-doing it. I'd like a fix to stop it happening in the first place, such as that provided for Excel XP in SP3. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table report discarded in Excel 2003 - any fix available
I'm not sure there is one.
Each version of excel seems to be sensitive to different levels of corruption. Usually, the newer versions can handle it better than the earlier version--but not always. You may want to try rebuilding the workbook to see if that helps. Desperate Don wrote: "Dave Peterson" wrote: I don't understand how auto-recovery would affect your problem (I'd suspect a coincidence if I were a betting person). But it sounds like the workbook is corrupted to me. Lots of people have praised OpenOffice.org for saving their data and code. http://www.openoffice.org, a 60-65 meg download or a CD There are commercial recovery services. I've never used it, but you might want to check into: http://www.officerecovery.com Desperate Don wrote: When I open an Excel workbook in Excel 2003, I occasionally get the message: "Errors were detected in file 'path\Accounts.xls' "The following is a list of repairs: "PivotTable report 'PivotTable1' on '[Accounts.xls]Analysis ex VAT' was discarded due to integrity problems.W" I note there appears to be a fix for Excel XP (SP3) but I can't find a solution for Excel 2003. This problem did not occur with Excel 2000. A solution for Excel XP was to turn off auto-recover, but I don't want to do that. Any ideas? -- Dave Peterson Thanks for reply. I can recover the Pivot Table by re-doing it. I'd like a fix to stop it happening in the first place, such as that provided for Excel XP in SP3. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Memory Issue - Excel crashes | Excel Discussion (Misc queries) | |||
Excel Pivot Table with Access | Excel Discussion (Misc queries) | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
convert excel list to pivot table | Excel Discussion (Misc queries) |