D
Dan_Connors
Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel
First, on the Windows version, selecting a cell that is in a Pivot Table automatically inserts the cell in the GETPIVOTDATA format. The advantage is that if the location of that cell changes, the reference doesn't. In the Mac version, the reference is simply to the cell and if the pivot table changes, the reference does not. I've discovered that I can manually use the GETPIVOTDATA format, however I often get an #N/A error if the cell I am referencing has the word "Cash" in it. Finding that hard to understand.
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel
First, on the Windows version, selecting a cell that is in a Pivot Table automatically inserts the cell in the GETPIVOTDATA format. The advantage is that if the location of that cell changes, the reference doesn't. In the Mac version, the reference is simply to the cell and if the pivot table changes, the reference does not. I've discovered that I can manually use the GETPIVOTDATA format, however I often get an #N/A error if the cell I am referencing has the word "Cash" in it. Finding that hard to understand.