Thread: turn off GetPivotData in 2007

Is there a way to turn on and off the automatic GetPivotData function in Excel 2007 like there was in 2003. I havent been able to find a button or otherwise like 03 has. Thanks.

Generate GetPivotData setting in the PivotTable group on the Options tab

Mashley,


See if this helps:

1. Click the Microsoft Office Button, click Excel Options, and then click the Formulas tab.
2. Make sure that the Use GetPivotData functions for PivotTable references check box is selected, and then click OK.
3. Click in the worksheet.
4. Click the Options tab, click Options in the PivotTable group, and then click to clear the Generate GetPivotData check box.


Regards,

K