getpivotdata

  • Thread starter Thread starter TUV - YL
  • Start date Start date
T

TUV - YL

How do I turn off the getpivotdata feature? I do not want
to use it in my formulas that reference a pivot table.
 
Hi
don't think you can turn this of. Simply enter the cell reference
manually (without using the mouse to select the cell)
 
View / Toolbars / PivotTable Toolbar - Look for square icon with a smaller
square in top left corner - Hit it to toggle the feature on/off
 
Hey stranger, hope all's well :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



Stephen Bullen said:
Hi Tuv,


In Excel 2002 and up, you can add a toolbar button to toggle whether they're generated.

If you go to Tools / Customize, look on the Commands tab for "Generate
Click to expand...
GetPivotData" near the bottom of the Data section. Drag the icon to
 
LOL - and from the look of the time you should be able to tell me whether all's
well with me in one hours time, right now!!! :-)
 
Hi Tuv,
How do I turn off the getpivotdata feature? I do not want
to use it in my formulas that reference a pivot table.
Click to expand...

In Excel 2002 and up, you can add a toolbar button to toggle whether they're generated.

If you go to Tools / Customize, look on the Commands tab for "Generate GetPivotData" near the bottom of the Data section. Drag the icon to
an existing toolbar - the pivot toolbar is a good choice.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie
 
Hi Ken,
LOL - and from the look of the time you should be able to tell me whether all's
well with me in one hours time, right now!!! :-)
Click to expand...

Find thanks, but one of us has our clocks or time zones wrong, huh?

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getpivot data dynamic reference 1
GETPIVOTDATA #REF! error XL2003/2010 1
getpivotdata 1
Use cell_ref in place of an item in get pivot data function 2
GetPivotData Multiple Fields 6
2003 formula for Pivot 1
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0

Back
Top