Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FUNCTION GETPIVOTDATA MICROSOFT EXCEL 2003 VS EXCEL 2004 FOR MAC
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,f ield2,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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FUNCTION GETPIVOTDATA EXCEL 2003 v EXCEL 2004 FOR MAC | Excel Worksheet Functions | |||
Help on Microsoft Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 Slow Function Argument Window | Excel Discussion (Misc queries) | |||
How do I report a Date Format bug in Excel 2003 to Microsoft ? | Excel Discussion (Misc queries) | |||
Help with Charting My Data -- | Charts and Charting in Excel |