Toggle for GetPivot Data in Office 2007 Excel

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!
 
T

trip_to_tokyo

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.
 
T

trip_to_tokyo

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
Getpivot function - 2
Disable automatic GETPIVOT 3
Getpivot data dynamic reference 1
Select a cell in a Pivot table 2
if function checking for numerical data vs alpha characters 1
Use cell_ref in place of an item in get pivot data function 2
how do i avoid a formula in excel2003 automatically using getpivot 1

Top