LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default GetPivotData and cell references

Hi, I am trying to build a GetPivotData formula that uses cell references for
all the fields in the function. i have not been successful in substituting a
cell reference for the data_field - get a #REF! result. Using Excel/Office
2003.

Thanks for any suggestions

Marc
 
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
Multiple Cell References in GetPivotData Sarah (OGI) Excel Worksheet Functions 4 May 18th 07 05:42 PM
reference another cell in getpivotdata function Sarah (OGI) Excel Worksheet Functions 4 April 25th 07 05:12 PM
GETPIVOTDATA - HOW TO USE CELL REFERENCE? SSJ New Users to Excel 5 March 28th 07 08:59 PM
Getpivotdata references have stopped loading pivot-refreshed value RickJ7777 Excel Worksheet Functions 1 February 8th 07 03:46 PM
How to rename references from range names to cell references Abbas Excel Discussion (Misc queries) 1 May 24th 06 06:18 PM


All times are GMT +1. The time now is 08:05 AM.

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

About Us

"It's about Microsoft Excel"