Get rid of GETPIVOTDATA Option

If you want to disable the Generate GetPivotData setting, follow these steps, as appropriate for the version of Excel that you are running.

Microsoft Excel 2003

1. On the Tools menu, click Customize.
   
2. Click the Toolbars tab, and then click to select the PivotTable check box. The PivotTable toolbar is displayed.
   
3. Click Close.
   
4. On the PivotTable toolbar, click the Toolbar Options arrow. This arrow appears on the right end of the toolbar.
   
5. Click Add or Remove Buttons, click PivotTable, and then select Generate GetPivotData.
   
6. Click in the worksheet.
   
7. Click the Generate GetPivotData button that now appears on the PivotTable toolbar. When you click this button, it is turned on or off. If the button is selected, the GETPIVOTDATA formula is automatically generated.
   

Excel 2007

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.