Can you get around the GETPIVOTDATA command when referencing a pi.

G

Guest

In Excel 2003, when you reference a cell in a pivot table now instead of
getting a simple cell reference you now get a GETPIVOTDATA function return
which is a pain when trying to copy a formula outside of the pivot table. Is
there anyway to get around this?
 

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

Pivot Table with Data Model Connection - getpivotdata reference issue 0
2007 Excel - GETPIVOTDATA 2
GETPIVOTDATA and (blank) 0
Pivot Table with Data Model Connection - getpivotdata #REF error 0
GETPIVOTDATA from OLAP cube - grouped field 0
reference another cell in getpivotdata function 4
Change GETPIVOTDATA cell reference to A1 style 1
GetPivotData from OLAP Cube Cell Referencing Formula. 1

Top