![]() |
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? |
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