LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default GETPIVOTDATA Question

I'm trying to reference pivot table cells in another worksheet; a direct cell
reference doesn't work because the data is ever-changing. I figured out the
formula if I'm in the same tab, but not from a secondary worksheet.

The same-tab formula is: =GETPIVOTDATA("Budget",$A$4,"Office","ATL")

How do I re-write that to work from another worksheet? I have many others
to do, but I need the basic structure to follow.

Thanks for your help.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getpivotdata Question mariaivelisse77 Excel Discussion (Misc queries) 3 December 30th 08 09:46 PM
GetPivotData Question Barb Reinhardt Excel Worksheet Functions 1 May 9th 08 12:34 AM
getpivotdata geebee Excel Worksheet Functions 2 November 17th 07 04:55 PM
GETPIVOTDATA help Matt Excel Discussion (Misc queries) 2 October 12th 06 03:39 PM
GETPIVOTDATA question regarding adding "rows" CamiK Excel Worksheet Functions 1 November 24th 05 03:35 AM


All times are GMT +1. The time now is 04:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"