ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can you get around the GETPIVOTDATA command when referencing a pi. (https://www.excelbanter.com/excel-worksheet-functions/5961-can-you-get-around-getpivotdata-command-when-referencing-pi.html)

NewExcel2003User

Can you get around the GETPIVOTDATA command when referencing a pi.
 
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?

Frank Kabel

Hi
see:
http://www.contextures.com/xlPivot06.html

--
Regards
Frank Kabel
Frankfurt, Germany

"NewExcel2003User" schrieb
im Newsbeitrag
...
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?




All times are GMT +1. The time now is 09:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com