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 reportTo edit the data source, you must use the PivotTable Wizard (use the keyboard combination Command + Option + P).
This PivotTable has the "Query external data source as you select each report filter field item" option turned on and slicers ...
This PivotTable list could not be imported correctly by Excel and data may have been lost. If you need to work with this ...
This PivotTable report field is grouped. You cannot add a calculated item to a grouped field.To ungroup the field, make sure ...
This PivotTable report is based on the same data as at least one other PivotTable report. Clearing the PivotTable report ...
This PivotTable report was created in one of the following ways: From multiple consolidation ranges With the Query external ...
This removes the subtotals and sorts again.If you want to sort the subtotaled groups, choose the Cancel button; then collapse ...
This selection is not valid.There are several possible reasons: Select a paste area that will not conflict with the original ...
This sheet contains a query that is currently being edited by Microsoft Query.You will not be able to use Microsoft Query ...
This slicer is already connected to another PivotTable which has grouped fields, or this PivotTable has grouped fields and ...