XL: PivotTable Wizard Does Not Automatically Refresh Data

ID: Q106243


The information in this article applies to:
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a
  • Microsoft Excel for Windows NT, version 5.0
  • Microsoft Excel for Windows 95, versions 7.0, 7.0a
  • Microsoft Excel 97 for Windows


SYMPTOMS

In Microsoft Excel, 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 the versions of Microsoft Excel listed at the beginning of this article.


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 field names, click PivotTable Field on the Data menu.


REFERENCES

"User's Guide," version 5.0, Chapter 25

For more information about customizing PivotTables, click the Search button in Help and type:

pivot tables, customizing

Additional query words: 8.00 97 XL97 database list pivot tables

Keywords : kbualink97 kbdta xllist xlpivot
Version : WINDOWS:5.0,5.0c,7.0,97; MACINTOSH:5.0,5.0a
Platform : MACINTOSH WINDOWS
Issue type : kbprb


Last Reviewed: October 7, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.