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

.

.

 

[Guest]

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

 

[fyz]

Hi,



I used to have a similar problem. I think you can try a popular Excel file recovery tool called Advanced Excel Repair to repair your Excel file. It is a powerful tool to repair corrupt or damaged Excel files and it helps me a lot.



Detailed information about Advanced Excel Repair can be found at http://www.datanumen.com/aer/



And you can also download a free demo version at http://www.datanumen.com/aer/aer.exe


Hope the information will help.

Alan

 

[greggy8]

Hi,

Yeah this is a real pain. I work for an organisation that would not apply SP3. The way I got around this problem was to remove all passwords, then use a macro to set the protection on and off at the time the Excel workbook opens. I also disabled the Protection menu, to prevent users from manually playing with the protection settings. Not perfect, but achieved what i wanted, which was a robust template. Basic code I used attached:

Sub DISABLE_PROTECTION_FUNCTION()
On Error Resume Next

Dim oCtrl As Office.CommandBarControl
For Each oCtrl In Application.CommandBars.FindControls(ID:=30029)
oCtrl.Enabled = False 'Set To True To Re-enable
Next oCtrl
End Sub


Sub Protect_Worksheet(PWorksheetName As String)
'No Passwords are set, because it can cause Pivottable Corruption - see Microsoft bug

ActiveWorkbook.Protect

If (PWorksheetName = "") Then

Sheets("Receipts").Protect , DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowFiltering:=True

Sheets("Payments").Protect , DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowFiltering:=True

Sheets("BankStmt").Protect , DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowFiltering:=True

Sheets("Instructions").Protect , DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowFiltering:=True

Else

Sheets(PWorksheetName).Protect , DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowFiltering:=True

End If

End Sub



Sub Unprotect_Worksheet(PWorksheetName As String)

ActiveWorkbook.Unprotect

If (PWorksheetName = "") Then
Sheets("Receipts").Unprotect
Sheets("Payments").Unprotect
Sheets("BankStatementPDF").Unprotect
Sheets("Instructions").Unprotect
Else
Sheets(PWorksheetName).Unprotect Password:="trust"
End If

End Sub