FUNCTION GETPIVOTDATA EXCEL 2003 v EXCEL 2004 FOR MAC

  • Thread starter FRANCISCO PEREZ-LANDAETA
  • Start date
F

FRANCISCO PEREZ-LANDAETA

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 report. This information is used to determine which
PivotTable report 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 reports, 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 report that
contains the data you want to retrieve. Pivot_table can be a cell or range
of cells in the report, a name for the range that contains the PivotTable
report, or a label stored in a cell above the PivotTable report.
Name is a text string enclosed in double quotation marks that describes
the cell in the PivotTable report 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top