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
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.
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
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
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?
2003 has this anoying GETPIVOTTABLE function. Did you ever find a way to
disable this?
Debra Dalgleish
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:
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