XL98: PivotTable Wizard Does Not Automatically Refresh Data (193697)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q193697 SYMPTOMS
In Microsoft Excel 98 Macintosh Edition, when you change the data or the
field name of a list that is included in a PivotTable, and you then start
the PivotTable Wizard, the information in the existing PivotTable is not
updated unless you click Refresh Data on the Data menu.
CAUSE
This behavior is by design of Microsoft Excel 98 Macintosh Edition.
WORKAROUND
To refresh the data, click Refresh Data on the Data menu.
MORE INFORMATION
You can use the PivotTable Wizard to change the list range, the
arrangement of fields in the page, column, row, or data areas, and the
location of an existing PivotTable. However, the PivotTable Wizard does
not automatically update the data in the existing PivotTable.
After you create a PivotTable, you can select a cell in the PivotTable and
click PivotTable on the Data menu to display the source information.
However, clicking this command does not automatically refresh the data.
NOTE: Changing the field names in the original list may cause inaccurate
results when the PivotTable data is refreshed. To change a field name,
select the field in the PivotTable, and click PivotTable Field on the
PivotTable toolbar.
REFERENCES
For more information about refreshing PivotTable data, click Contents And
Index on the Help menu (or on the Balloon Help menu if you are using a
version of the Macintosh operating system earlier than 8.0), click the
Index button in Microsoft Excel Help, type the following text
and then click Show Topics. Select the "Refresh a PivotTable or change its
source data" topic, and click Go To. If you are unable to find the
information you need, ask the Office Assistant.
| Modification Type: | Major | Last Reviewed: | 9/11/2002 |
|---|
| Keywords: | kbprb KB193697 |
|---|
|