GETPIVOTDATA() returns N/A on Mac only

H

Heath Perryman

I'm running 2004 on my Mac and 2003 on my Windows box. Opening the same
spreadsheet is giving different results on each version without me changing
anything. Here is my formula:

=GETPIVOTDATA('Find pivots'!$A$3,TEXT(A2,"m/d/yyyy"))

On Windows, this correctly returns the contents of a cell in the table. On
the Mac, it returns N/A.

Any ideas? Workarounds?

Thanks,

Heath
 
J

JE McGimpsey

Heath Perryman said:
I'm running 2004 on my Mac and 2003 on my Windows box. Opening the same
spreadsheet is giving different results on each version without me changing
anything. Here is my formula:

=GETPIVOTDATA('Find pivots'!$A$3,TEXT(A2,"m/d/yyyy"))

On Windows, this correctly returns the contents of a cell in the table. On
the Mac, it returns N/A.
Click to expand...

Macs and Windows have different default date systems. You may notice
that your value in A2 is 4 years and 1 day off from the value you see in
WinXL.


Try choosing Preferences/Calculation and unchecking the 1904 date system
checkbox.
 
H

Heath Perryman

That option was actually already off. Any other possibilities? Are there
differences in the date handling that may mean I need to change the m/d/yyyy
to something else? I tried a few variations but with no success.

Thanks very much!

Heath
 
J

JE McGimpsey

Heath Perryman said:
That option was actually already off. Any other possibilities? Are there
differences in the date handling that may mean I need to change the m/d/yyyy
to something else? I tried a few variations but with no success.
Click to expand...

I can't think of any others, but the date system is a workbook setting -
did you check the workbook in question?
 
H

Heath Perryman

I can't think of any others, but the date system is a workbook setting -
did you check the workbook in question?
Click to expand...

Yes, definitely set the preference for the workbook. Actually tried toggling
the setting, saving and toggling back, but no difference. Are there any
known issues with this function on Mac compared to Windows?

Heath
 
J

Jeff F.

Another feature missing? I'm losing my formatting of the pivot table
on my mac went moved from my PC. Did you notice that the report
format option on the pivot table toolbar is missing? Very
disappointing if this is true.
 
Top