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.
to use it in my formulas that reference a pivot table.
F
Frank Kabel
Hi
don't think you can turn this of. Simply enter the cell reference
manually (without using the mouse to select the cell)
don't think you can turn this of. Simply enter the cell reference
manually (without using the mouse to select the cell)
K
Ken Wright
View / Toolbars / PivotTable Toolbar - Look for square icon with a smaller
square in top left corner - Hit it to toggle the feature on/off
square in top left corner - Hit it to toggle the feature on/off
K
Ken Wright
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
----------------------------------------------------------------------------
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------
GetPivotData" near the bottom of the Data section. Drag the icon toStephen Bullen said:
K
Ken Wright
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!!!
well with me in one hours time, right now!!!
S
Stephen Bullen
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 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
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
S
Stephen Bullen
Hi Ken,
Find thanks, but one of us has our clocks or time zones wrong, huh?
Regards
Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie
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!!!
Find thanks, but one of us has our clocks or time zones wrong, huh?
Regards
Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie
T
TUV - YL
I could not find the icon. How do I get at this from the
menu?
menu?
T
TUV - YL
Got it. Thanks all.
K
Ken Wright
You don't - What version Excel do you have?