The information in this article applies to:
SYMPTOMSIn 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. CAUSEThis behavior is by design of the versions of Microsoft Excel listed at the beginning of this article. WORKAROUNDTo 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.
REFERENCES
"User's Guide," version 5.0, Chapter 25
pivot tables, customizing Additional query words: 8.00 97 XL97 database list pivot tables
Keywords : kbualink97 kbdta xllist xlpivot |
Last Reviewed: October 7, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |