XL2000: Help Topic for Refresh Method Is Incomplete for Chart Object (228618)


The information in this article applies to:

  • Microsoft Excel 2000
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
Modification Type:MinorLast Reviewed:10/10/2006
Keywords:kbbug kbchart kbpending kbProgramming KB228618
©2004 Microsoft Corporation. All rights reserved.