Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

disable get pivot table function

486 views
Skip to first unread message

Brock@discussions.microsoft.com Wanda Brock

unread,
Apr 24, 2007, 10:14:01 PM4/24/07
to
Want to create formulas outside of a pivot table yet still reference the data
within the pivot table. I can manually write the cell name such as
=E7+E9....but want to create the formula by clicking in the cell without
automatically getting the getpivottable funtion. Is it possible to disable
this function? I use the get pivot table function quite frequently and
successfuly but in this instance don't want it.

Roger Govier

unread,
Apr 25, 2007, 7:55:08 AM4/25/07
to
Hi Wanda

Debra Dalgleish explains how to do this at her site
http://www.contextures.com/xlPivot06.html

--
Regards

Roger Govier


"Wanda Brock" <Wanda Br...@discussions.microsoft.com> wrote in message
news:A905C890-B9BF-4199...@microsoft.com...

tom

unread,
Dec 31, 2007, 10:09:00 AM12/31/07
to
I have the same problem. It worked great in earlier Excel version but now
2003 has this anoying GETPIVOTTABLE function. Did you ever find a way to
disable this?

Debra Dalgleish

unread,
Dec 31, 2007, 12:51:04 PM12/31/07
to
There are instructions here for adding the Generate GetPivotData button
to a toolbar, and toggling the feature on and off:

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

When it's turned off, you will create a normal reference when you click
on a cell in the pivot table.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

0 new messages