Toggle for GetPivot Data in Office 2007 Excel
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! |
Toggle for GetPivot Data in Office 2007 Excel
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. "Warm FL" wrote: 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! |
Toggle for GetPivot Data in Office 2007 Excel
My first options will be highlighted in red just below the PivotTable Tools
(also highlighted in red) in the Title Bar. "trip_to_tokyo" wrote: 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. "Warm FL" wrote: 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! |
All times are GMT +1. The time now is 08:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com