PRB: Pivot Table in Excel Does Not Update

This article was previously published under Q129308
This article has been archived. It is offered "as is" and will no longer be updated.
SYMPTOMS
If you create a Pivot Table in Microsoft Excel using Visual FoxPro's PivotTable Wizard and then change the data in the table on which the Pivot tableis based, the Excel Pivot Table does not update to reflect the change inthe underlying data.
RESOLUTION
To update the data, right click any cell in the Pivot Table in Excel. Thenchoose Refresh Data from the context sensitive menu.
STATUS
This behavior is by design because of performance issues associated withMicrosoft Query having to retrieve data from a FoxPro table in Excel.
MORE INFORMATION
The FoxPro ODBC driver passes data to Microsoft Query. Excel then retrievesthe data from Microsoft Query. For the data to be automatically updated inthe Pivot Table, FoxPro would have to notify Microsoft Query every timedata changes in a table on which a Pivot Table is based.
VFoxWin 3.00
Properties

Article ID: 129308 - Last Review: 02/24/2014 08:19:54 - Revision: 2.1

Microsoft Visual FoxPro 3.0 Standard Edition, Microsoft Data Access Components 2.5

  • kbnosurvey kbarchive kbprb KB129308
Feedback