PIVOT DATA TABLES EXCEL 2004 VS EXCEL 2003 FOR WINDOWS

[FRANCISCO PEREZ-LANDAETA]

JIM


Basically, the problems seems to be the syntax. When
opened in my MAC all I get is #VALUE!. Hoever, when opened in Windows, it
opens beautifully. I really need to make it work because I am pulling a
great deal of date from the dynamic tables to construct a budget of
operations.

It is interesting because the MAC Syntax in Windows works. But, not the
other way around. The Syntax in Windows is more complex and uses more
parameters.

I will give you an example :

MICROSOFT EXCEL 2004 FOR MAC

=+GETPIVOTDATA(ResumenLiquidadas!A5,"DATOS SUMA DE BIG ROME RANCHO GRANDE")


MICROSOFT EXCEL 2003 FOR WINDOWS

=+GETPIVOTDATA("Suma de BIG ROME",ResumenLiquidadas!$A$3,"FINCA","RANCHO
GRANDE")


This is simply pulling data from a table called "ResumenLiquidadas".
Like I said before, the MAC formula works in excel for windows but not the
other way around.

Both formulas yield the same result in excel for windows but not in excel
for MAC.


The second question is :

How can one copy/paste this formula so that the concepts in the pivotable
are shared and one doesnot have to type ( in the MAC case) the same info
over and over.

For example:

+GETPIVOTDATA(ResumenLiquidadas!A5,"DATOS SUMA DE BIG ROME RANCHO GRANDE")
+GETPIVOTDATA(ResumenLiquidadas!A5,"DATOS SUMA DE BIG ROME LOS AMIGOS")

And so on.....

Let me know where I should post the file. But, meanwhile I can tell you that
the syntax is not understood in EXCEL 2004 for MAC.

I hope there is a fix for this, because right now I don't have an option to
work without it. It will take a great deal of time to modify all the fields
or syntax configuration in EXCEL to make it work in EXCEL for MAC.

Is there a work around ? Or am I doomed ? When, will there be an update to
the Apple suite ?, how soon ? PIVOTCHARTING is also missing in the MAC
version.

I will wait for you to tell where to send the file or to post the file



Best regards,

Francisco

 

[Mike Middleton]

Francisco -

According to Mac Excel 2004 built-in Help, it is very clear that the
GETPIVOTDATA function in Mac Excel 2004 supports only two arguments (just
like the same function in Windows Excel 97). So, if you want to use the same
function on both Mac Excel 2004 and Windows Excel 2003, you will need to use
only two arguments.

I develop add-ins to run on both Mac and Windows versions of Excel. I use
Windows Excel 97 VBA to develop these add-ins, and then I test on later
versions of Mac and Windows. It is always recommended to use the earliest
platform for development and then to test on later versions. Mac Excel VBA
is a version or so behind Windows Excel VBA. It appears that some Mac Excel
worksheet functions are also behind.

Regarding your second question, if the text strings for the second argument
of the GETPIVOTDATA function are in worksheet cells, then perhaps you could
use a lookup function as the second argument. With proper cell references in
the lookup function, then you might be able to copy the GETPIVOTDATA
function to obtain the results you want.

- Mike
www.mikemiddleton.com