Pivot Table ERROR - corrupt??

[Guest]

Hey all,

I have a file which keeps having problems. The file is
mainly used in excel2002 SR3. I then go into it with
XL2000 SR1 and get an error something similar to "cannot
read file".

Then if its opened up in XL2002 again - it asks if we wish
to repair the file. Then it says " Errors were detected in
file 'F:\XXXX\XXXX JUNE 2004.xls'
The following is a list of repairs:

PivotTable report 'PivotTable1' on '[XXXX JUNE 2004.xls]
Sheet1' was discarded due to integrity problems."

and then the pivot table is made into just values. Any
ideas what is causing this or how to solve??

Regards

Dan

 

[Guest]

just found

http://support.microsoft.com/default.aspx?scid=kb;en-
us;819853

but i already have sp3

 

[JohnUk]

Hi Dan
I am having the exact same problem. I also have the SP3,
but another suggestion came my way, but it hasn't been
fully tested yet
If a pivot table has a lot of information in it, it may
course problems. I have a workbook that has nearly 30
pivot tables in it, but 10 of them are copies of the
first one, but extracts different information. So I have
created new pivots based on the same source in the hoping
that it would solve the problem.
John

-----Original Message-----
just found

http://support.microsoft.com/default.aspx?scid=kb;en-
us;819853

but i already have sp3

-----Original Message-----
Hey all,

I have a file which keeps having problems. The file is
mainly used in excel2002 SR3. I then go into it with
XL2000 SR1 and get an error something similar to "cannot
read file".

Then if its opened up in XL2002 again - it asks if we wish
to repair the file. Then it says " Errors were detected in
file 'F:\XXXX\XXXX JUNE 2004.xls'
The following is a list of repairs:

PivotTable report 'PivotTable1' on '[XXXX JUNE 2004.xls]
Sheet1' was discarded due to integrity problems."

and then the pivot table is made into just values. Any
ideas what is causing this or how to solve??

Regards

Dan
----------------------------------------
There are 2 types of computer, the prototype and the
obsolete!!

.

.

 

[tfarabaugh]

I have gotten the same issues whenever I password protect a workbook (not the
weorksheet, but the whole workbook) that has pivot tables in it. When I
remove the workbook protection it is fine. However, there are instances when
I would like to have the workbook protection on. I have found workarounds
(making the sheets xlVeryHidden so they do not show up in the unhide
worksheets list primarily), but I would like to avoid having to go to the
extra trouble.

Is your workbook protected? If so, try unprotecting a version of it before
it removed the pivot tables and that might fix it.

I think that this is an issue that Microsoft needs to adress, as I have seen
many complaints about it but no real solution.

Hope this helps,

Tommy