XL98: PivotTable Wizard Does Not Automatically Refresh Data

• Microsoft Excel 98 Macintosh Edition

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

PivotTables, data source

Additional query words: XL98 database list pivot tables

Keywords : kbdta xllist xlpivot
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb