How do I just get a cell reference when referring to a pivot tabl.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I currently refer to a cell in the pivot table I get the whole
"=Getpivot...."string while I used to get only a cell reference.

Do you know what I do wrong.

Thanks
 
I've just begun to work with the Pivot Table area, but
(for now) it seems that if you want to reference a cell within
a pivot table DO NOT go the route "=" and then POINT to the PT Cell;
Instead, manually enter "=B15", or "=$B$15" (Without the quotes).
me thinks...
 
Debra,

Sorry for the late response but this is very helpfull. Thanks

Aad (The Netherlands)
 
Jim,

Thanks but this become more difficult when pointing to muliple cell and if
you want to change something. Next to this it will be very time consuming and
you probably make mistakes. I would consider the way Debrah pointed this out
by customizing the feature.
 

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

Similar Threads

Toggle for GetPivot Data in Office 2007 Excel 2
2003 formula for Pivot 1
Adding to an existing Pivot Table 7
Referencing a pivot tables Grand Totals Column 1
Select a cell in a Pivot table 2
Easy way to change Pivot table source files? 5
Copy data from pivot table using relative reference 5
Pivot Table with Data Model Connection - getpivotdata reference issue 0

Back
Top