XL2000: Help Topic for Refresh Method Is Incomplete for Chart Object

ID: Q228618

The information in this article applies to:

Microsoft Excel 2000

SYMPTOMS

The online Help for the Refresh method includes the following statement:

expression
Required. An expression that returns a Chart, PivotCache, or QueryTable object.

This is not entirely correct. The Refresh method does not clearly explain the use of the Refresh method for the Chart object as it applies to a PivotChart Report. ActiveChart.Refresh will not update a PivotTable's PivotCache or PivotChart.

RESOLUTION

To refresh the data in a PivotChart report, you must update the PivotCache using a statement similar to the following:


ActiveChart.PivotLayout.PivotCache.Refresh

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

You can update data in a PivotChart created from a PivotTable with a Visual Basic macro by using the Refresh method. However, if you search the Microsoft Visual Basic Help for the Refresh method topic, you will not find a specific example for how to update the data in your PivotChart. The Help file states that the Refresh method applies to the Chart object. Although this is true, the Help file does not state that to update data in your chart, you must use a statement similar to the following:


Charts(1).PivotLayout.PivotCache.Refresh

Additional query words: OFF2000 XL2000

Keywords : kbdta kbchart xlpivot
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug