If you don't see the PivotTable you want in the list:The PivotTable might be in a different workbook. Copy the PivotTable from the other workbook into this workbook. You can then create another PivotTable from it.The PivotTable might have page fields that are set up to query for the external data for each item separately. If you have enough memory to change the page fields back to regular page fields, you can then create another PivotTable from the existing PivotTable.
If you clicked a cell in your list before you started the PivotTable Wizard, Microsoft Excel has automatically detected a ...
If you continue, the previous PivotTable formatting will be lost the next time you refresh the PivotTable or change the layout. ...
If you do not select a range first, list management commands act on the range named 'Database'. If you want another range, ...
If you don't know which function to use, type a brief description of what you want to do in the box, and then click Search. ...
If you don't see the PivotTable you want in the list:The PivotTable might be in a different workbook. Copy the PivotTable ...
If you don't want to be prompted for summary information when you save a new workbook, choose Preferences from the Edit menu, ...
If you don't want to edit directly in cells, choose Preferences from the Edit menu and then clear the 'Edit Directly in Cell' ...
If you don't want to paste objects along with cells, choose Preferences from the Edit menu, and then clear the 'Cut, Copy, ...
If you double-click the Format Painter button it will stay selected so that you can paint multiple areas with the same formats. ...