P
phuzz
The function GetPivotData exists in both Excel for Mac (04 and 08), and in
the Windows version (03 and 07 for sure, probably other versions as well.)
However, while the function performs the same task on both systems, the
syntax is different.
The Windows syntax is
GETPIVOTDATA(data_field,pivot_table)
(http://office.microsoft.com/en-us/excel/HP100624771033.aspx)
The Mac syntax is:
GETPIVOTDATA(pivot_table,name) where name refers to the same parameter as
data_field abov
(http://www.microsoft.com/mac/help.mspx?target=9e985a8c-3d6c-4886-9137-d6b823e504a71033&clr=99-1-0)
As you can see, the syntax is reversed on the Mac, which causes spreadsheets
to break when viewed on a Mac.
Excel 2007 does understand the reverse syntax of the Mac version, so it is
possible to create one sheet that will work on both platforms, but it would
be very helpful if the behaviour of this function was consistent across
platforms.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/communitie...cb3a7f33&dg=microsoft.public.mac.office.excel
the Windows version (03 and 07 for sure, probably other versions as well.)
However, while the function performs the same task on both systems, the
syntax is different.
The Windows syntax is
GETPIVOTDATA(data_field,pivot_table)
(http://office.microsoft.com/en-us/excel/HP100624771033.aspx)
The Mac syntax is:
GETPIVOTDATA(pivot_table,name) where name refers to the same parameter as
data_field abov
(http://www.microsoft.com/mac/help.mspx?target=9e985a8c-3d6c-4886-9137-d6b823e504a71033&clr=99-1-0)
As you can see, the syntax is reversed on the Mac, which causes spreadsheets
to break when viewed on a Mac.
Excel 2007 does understand the reverse syntax of the Mac version, so it is
possible to create one sheet that will work on both platforms, but it would
be very helpful if the behaviour of this function was consistent across
platforms.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/communitie...cb3a7f33&dg=microsoft.public.mac.office.excel