Hi,
I have the following situation :
I created a spreadsheet in microsoft excel 2003 for windows and used the
GETPIVOTDATA function. I later tried opening the same file on my MAC (
Excel
2004 for MAC ) and the getpivotdata function didn't work. The message I
receivedd on the where I used the function was a #VALUE! Error.
I revised the syntax for WINDOWS and MAC and came to the conclusion that
both Application use different syntax's. I am writing on this forum to see
if anyone has come across the same issue and has already solved it.
It is a really pity that this function is not carried out to work on the
MAC
the same way it is on Windows, ( at least that is my conclusion )
This is the syntax used in Windows :
=GETPIVOTDATA("Sum of BIG ROME",ResumenLiquidadas!$A$3,"FINCA","RANCHO
GRANDE")
GETPIVOTDATA(data_field,pivot_table,field1,item1,field2,item2,...)
Data_field is the name, enclosed in quotation marks, for the data field
that contains the data you want to retrieve.
Pivot_table is a reference to any cell, range of cells, or named range
of
cells in a PivotTable re****t. This information is used to determine which
PivotTable re****t contains the data you want to retrieve.
Field1, Item1, Field2, Item2 are one to 14 pairs of field names and
item
names that describe the data you want to retrieve. The pairs can be in any
order. Field names and names for items other than dates and numbers are
enclosed in quotation marks. For OLAP PivotTable re****ts, items can
contain
the source name of the dimension as well as the source name of the item. A
field and item pair for an OLAP PivotTable might look like this:
"[Product]","[Product].[All Products].[Foods].[Baked Goods]"
If anyone can help me, I will appreciated a lot.
I hope there is an easy way to solve this issue and not loose the
operation
and calculations on my spreadsheet.
The syntax used in MICROSOFT EXCEL 2004 IS :
GETPIVOTDATA(pivot_table,name)
Pivot_table is a reference to a cell in the PivotTable re****t that
contains the data you want to retrieve. Pivot_table can be a cell or range
of cells in the re****t, a name for the range that contains the PivotTable
re****t, or a label stored in a cell above the PivotTable re****t.
Name is a text string enclosed in double quotation marks that describes
the cell in the PivotTable re****t that contains the value you want to
retrieve.
I will be very grateful if anyone can help me.
Maybe I the solution is right here, but I cannot see it.
Thanks,
Francisco Perez-Landaeta
|
