Microsoft Office Tutorials and References
In Depth Information
Using GETPIVOTDATA to Retrieve One Cell from a Pivot Table
progid — This is the name of the program ID of a registered COM auto-
mation add-in that has been installed on the local computer. You need
to enclose the name in quotation marks.
server — This is the name of the server where the add-in should be
run. If there is no server and the program is run locally, leave this
• topic1, topic2,...
topic1, topic2,... — These are one to 253 parameters that together rep-
resent a unique piece of real-time data.
to Retrieve One Cell from a Pivot Table
You might turn to this topic to find out how to use most of the Excel functions.
However, for the GETPIVOTDATA function, you are likely to turn to this
book to find out why the function is being automatically generated for you.
Suppose that you have a pivot table on a worksheet. You should click out-
side the pivot table. Next, you type an equal sign and then with the mouse,
click one of the cells in the data area of the pivot table. Although you might
expect this to generate a formula such as =E9, instead, Excel puts in the for-
mula =GETPIVOTDATA("Sales",$B$5,"Customer","Astonishing Glass Com-
pany","Region","West"), as shown in Figure 12.43 .
GETPIVOTDATA to Retrieve One Cell from a Pivot Table
Figure 12.43. Excel inserts this strange function in the worksheet.
Excel inserts this strange function in the worksheet.
This function is annoying. As you copy the formula down to more rows, the
function keeps retrieving sales to Astonishing Glass in the West region. By
default, Excel is generating this function instead of a simple formula such
as =E9. This happens whether you use the mouse or the arrow keys to specify
the cell in the formula.