pivot table 'not valid' on Mac

[Willem]

Hello,
Can anyone help me with the following problem?
From a customer I got a workbook with pivot tables. The workbook was
originally created on a Windows computer (Excel 2003?) I can manipulate the
pivot tables on my Windows computer (W2000, Excel 2003).
Als I can open the workbook on my Mac (OS 10.3.9, Excel X) an see the pivot
tables.
But when I try to manipulate them (eg choose 'table options...' of 'field
settings ...') I get an error message: 'pivot table is not valid.'
I installed the Office2004TestDrive but get the same message there.Any
solution?
Thanks for your help
Willem van den Goorbergh

 

[DebbieM]

I had the same problem and found out that MAC and PC recognize dates
differently. 2005 entered in an Excel spreadsheet on a PC is read as
2009 in the MAC pivot table and you receive that error. So, I was told
to subtract 1462 from all dates on the MAC spreadsheet (because there
was a Feb 29, 1999 incorporated into computer dates that did not
exist). I'm not sure who found that out. I'm not sure if this helps
but at least you'll understand what is happening.
Debbie

 

[Willem]

Thanks DebbieM,
But I'm afraid no the pivot tables contain no dates. So how can this be
related?
Someone else advised me to 'imprt the pivot tables in a new document. But I
also cannot find out where and how to do that.
Data -> get external data offers no option to import pivot tables or excel
files.
Any more suggestions??
TIA,
Willem van den Goorbergh

"DebbieM" schreef:

 

[JE McGimpsey]

I had the same problem and found out that MAC and PC recognize dates
differently. 2005 entered in an Excel spreadsheet on a PC is read as
2009 in the MAC pivot table and you receive that error. So, I was told
to subtract 1462 from all dates on the MAC spreadsheet (because there
was a Feb 29, 1999 incorporated into computer dates that did not
exist). I'm not sure who found that out. I'm not sure if this helps
but at least you'll understand what is happening.

Debbie -

Actually both Mac and PC XL can work with the same date systems - choose
Preferences/Calculation, and check or uncheck the 1904 Date system
checkbox.

On either platform, XL will use the date system of the first workbook it
opens, so if you open a 1900 Date system workbook, any other workbooks
you open in that session will use that system, even if the workbook was
created using the 1904 system. Thus the 1462 correction.

BTW, the correction is for a non-existent 29 February 1900, not 1999.