Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

This article was previously published under Q228618

↑ Back to the top


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.

↑ Back to the top


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
				

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top


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
				

↑ Back to the top


Keywords: KB228618, kbprogramming, kbpending, kbchart, kbbug

↑ Back to the top

Article Info
Article ID : 228618
Revision : 5
Created on : 10/10/2006
Published on : 10/10/2006
Exists online : False
Views : 216