Microsoft KB Archive/228618

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

Article ID: 228618

Article Last Modified on 10/10/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q228618



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 that this is a problem in the Microsoft products that are 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: kbbug kbchart kbpending kbprogramming KB228618

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.