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.
 

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

Getpivotdata Question 3
Disable automatic GETPIVOT 3
Getpivot data dynamic reference 1
Getpivot function - 2
if function checking for numerical data vs alpha characters 1
Select a cell in a Pivot table 2
Use cell_ref in place of an item in get pivot data function 2
GETPIVOTDATA Link to External Pivot Table 1

Back
Top