Auto reference to a Pivot table

's Computer Specifications

Hi experts,

I've found it quite annoying of the new Excel XP function which put
GETPIVOTDATA function when I link a reference to one of the cells in
pivot table.

Any thoughts of how to inactivate this new function?

Thanks
Sunn

--
Message posted from http://www.ExcelForum.com

's Computer Specifications

There are instructions here for turning that feature off, by using the
Generate GetPivotData button.

http://www.contextures.com/xlPivot06.html#GetPivotData

sunnyma < wrote:
> I've found it quite annoying of the new Excel XP function which put a
> GETPIVOTDATA function when I link a reference to one of the cells in a
> pivot table.
>
> Any thoughts of how to inactivate this new function?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot Table - Reference is not valid	Sinner	Microsoft Excel Discussion	1	31st Mar 2007 09:19 PM
Pivot Table - Reference is not valid	Sinner	Microsoft Excel Worksheet Functions	1	31st Mar 2007 06:57 PM
Pivot table - Reference is not valid	Sinner	Microsoft Excel Misc	1	31st Mar 2007 06:47 PM
VBA Code for a pivot table to open database and to reference table current page	Pete Straman Straman via OfficeKB.com	Microsoft Excel Programming	0	21st Feb 2005 03:57 AM
Re: Pivot Table Auto Refresh and Auto Flow to columns	Frank Kabel	Microsoft Excel Misc	0	27th Jul 2004 07:29 PM