If you clicked a cell in your list before you started the PivotTable and PivotChart Wizard, Excel entered the source range for you. To enter a range in the box, type a reference or select the range directly on your worksheet. If you need to move the dialog box out of the way temporarily, click Collapse Dialog {bmp 364}.
If the user you selected is currently editing the workbook, this action will prevent the user from saving the workbook, and ...
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 ...