Pivot table discarded to due to integrity problems

[ZZZ]

Hi,

I have a client with a mid-sized workbook. On one page is a pivot table.
Occasionally, upon opening the workbook an message appears about errors
being detected in the pivot table. The result is that the workbook opens,
but the worksheet with the pivot has now become "flat data". The buttons are
gone, and the data is just static data, the ability to do any pivot
manipulation is gone.

This problem is not consistent.

Has anyone run across this before? Any ideas to avoid it?

Thanks,
KB

 

[Debra Dalgleish]

The information in the following MSKB article may help you:

"Unable to read file" error message when you open Excel file that
contains a PivotTable report
http://support.microsoft.com/default.aspx?id=819853

 

[George Nicholson]

Interesting article, (pertaining to Excel 2002/XP prior to SP3).

Unfortunately, I've seen this behaviour (or something remarkably similar) in
Excel 2003 upon occasion....

 

[KB]

Thanks for the link to the KB article . Looks like what I need.

Best,
Ken B