Pivot table discarded to due to integrity problems

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

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

ZZZ wrote:
> 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?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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....

--
George Nicholson

Remove 'Junk' from return address.



"Debra Dalgleish" <[email protected]> wrote in message
news:[email protected]...
> 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
>
> ZZZ wrote:
>> 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?
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>

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

Best,
Ken B


"Debra Dalgleish" <[email protected]> wrote in message
news:[email protected]...
> 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
>
> ZZZ wrote:
> > 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?
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>