Pivot Table file corruption

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

be.barnabus@mac.com - 21 Sep 2006 21:22 GMT

I have a simple spread sheet with one table. in attempting to create
pivot table from this table I am running into the following problem
(I'm running Excel 2004 v 11.2.5 under OS 10.4.7 on a MacBook Pro).
I am able to create and manipulate the pivot table and save tghe file
(which is password protected). When I try to re-open the file I am able
to enter the password then receive an error "Unable to open file" When
I attempt to opent the file in Excel 2003 under Windows I get the same
errorinitialy then the program makes a 2nd attempt and opens the file
with a flas of an error about pivot table integrity then creates a
normal table of the pivot table values at the time of the save. This
appears to have started happening after upgrading to the Intel based
Mac - Anyone have any thoughts?

Reply to this Message

Geoff Lilley - 22 Sep 2006 21:03 GMT

I get this all the time. If you have multiple worksheets with pivot
tables, this is a common occurrence.

The best advice I can give you is NOT to save files to your desktop,
and save the file with only ONE pivottable worksheet, and save it
instead of ~/Desktop, save it in ~/Documents.

That's the best advice I have.

Cheers,
Geoff Lilley
ruthlesslightning@gmail.com
Microsoft Office Master Instructor (2000/XP)
Apple Certified HelpDesk Specialist

> I have a simple spread sheet with one table. in attempting to create
> pivot table from this table I am running into the following problem
[quoted text clipped - 8 lines]
> appears to have started happening after upgrading to the Intel based
> Mac - Anyone have any thoughts?

Reply to this Message

Mac Forum / Applications / Excel / September 2006

Pivot Table file corruption