This PivotTable report was created in one of the following ways: From multiple consolidation ranges With the Query external ...

This PivotTable report was created in one of the following ways:  • From multiple consolidation ranges • With the Query external data source as you select each report filter field item option in the PivotTable Field Advanced Options dialog box selected • With the Optimize memory check box in the PivotTable and PivotChart Wizard Options dialog box selected • As a Scenario PivotTable report  To edit the data source, you must use the PivotTable and PivotChart Wizard (with the PivotTable report selected, press ALT+D+P). To add this wizard to the Quick Access Toolbar, click the Microsoft Office Button, click Excel Options, click Customize, and then add the PivotTable and PivotChart Wizard button (For more information, click the Help button on the Excel Options title bar).