Toggle for GetPivot Data in Office 2007 Excel

  • Thread starter Thread starter Warm FL
  • Start date Start date
W

Warm FL

Where is the Toggle to turn on/off the GetPivotData function. It is default
to on, and I want to turn it off, so I can just point to a cell in the pivot
table without using the Getpivot function.

Thanks for any help!
 
Click in Pivot Table.

Options

PivotTable group

Options - click on drop down arrow

Here you will find toggle called:-

Generate GetPivotData

Please hit Yes if my comments have helped.

Thanks.
 
My first options will be highlighted in red just below the PivotTable Tools
(also highlighted in red) in the Title Bar.
 
Back
Top