If you don't see the PivotTable report or PivotChart report you want in the list: · The report might be in a different workbook. Copy the report from the other workbook into this workbook. You can then create another report from it. · The report might have page fields that are set up to query 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 report from the existing report.
If the value in a PivotTable cell is affected by two or more calculated items, the value is determined by the last formula ...
If you already specified the data for the chart on the Data Range tab, the ranges, names, and labels are correct. However, ...
If you change this option, Microsoft Office Excel will erase the history of changes to this workbook. Users will no longer ...
If you clicked a cell in your list before you started the PivotTable and PivotChart Wizard, Excel entered the source range ...
If you don't see the PivotTable report or PivotChart report you want in the list: The report might be in a different workbook. ...
If you modify the query, columns that you deleted from the Excel external data range will reappear as new columns, unless ...
If you trust the source of this workbook, you can enable automatic query refresh. If you disable automatic query refresh, ...
If you turn off the Accept Labels In Formulas option, Microsoft Office Excel replaces any labels you used in formulas with ...
If you want the PivotTable report or PivotChart report on an existing worksheet, type or select the cell reference for only ...