Does anyone know how to turn off the GetPivotData function?
 

The new version of Excel automatically prefills the formula with the
GetPivotData function when I try to use Pivot Table data. I don't want to
have this prefilled. How do I disable this.

Does anyone know how to turn off the GetPivotData function?
 

....and Thank You to you too...

Like I say in my Excel classes:
If you think Excel should be able to do something, it usually can. You just
have to look in the right place.

Evidently, I never pursued this one far enough.

€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron


"Scott" wrote:

Thanks, I actually found something in one of the other posts that solved my
problem. Goto Tools\Customize\Commands Select Data Scroll Down to the
bottom of the functions listed and drag the GetPivotData Icon to one of your
toolbars. To Turn it on double click on the icon, to turn off double click
on icon.

Scott

"Ron Coderre" wrote:

I don't think you can turn off the automatic GetPivotData entry, but you can
try this:

Instead of selecting the pivot table cell to be used in your formula, type
in the cell address.

For example, if you try to use the pivot table value at cell B10 by
selecting it, Excel will build something like this:
=GETPIVOTDATA("Amount",$A$1,"Name","Part 1")
But, if you just type =B10...you'll still get the value in that cell.

Does that help?


Regards,
Ron


"Scott" wrote:

The new version of Excel automatically prefills the formula with the
GetPivotData function when I try to use Pivot Table data. I don't want to
have this prefilled. How do I disable this.

Does anyone know how to turn off the GetPivotData function?
 

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


Scott wrote:
The new version of Excel automatically prefills the formula with the
GetPivotData function when I try to use Pivot Table data. I don't want to
have this prefilled. How do I disable this.


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