Microsoft KB Archive Search

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.

  1. Home
  2. XL2000: Error Message When Editing Chart Linked to Closed Workbook

XL2000: Error Message When Editing Chart Linked to Closed Workbook

View products that this article applies to.

This article was previously published under Q211953

↑ Back to the top

Symptoms

When you attempt to edit a series on a chart that is linked to a closed workbook, the following error message may appear:
Reference is not valid. Reference must be to an open worksheet.

↑ Back to the top

Cause

This behavior can occur when the following conditions are true:
  • On the Chart menu, you click Source Data.

    -and-
  • You click the Series tab and attempt to select an option.

    -or
  • You click the Series tab, and then you click the Data Range tab.
This behavior occurs when a reference is made to a closed workbook. References must be to an open workbook.

↑ Back to the top

Workaround

To work around this behavior, follow these steps to open the source workbook:
  1. On the Edit menu, click Links.
  2. Select the appropriate source file, and then click Open Source. You can now update the data series using either the Source Data command or the Chart Wizard.

↑ Back to the top

More information

When you close the workbook and use the Chart Wizard, some functionality, such as the ability to change the chart type, is not available. Note that you cannot use the Source Data command on the Chart menu. If you do so, the error message described in the "Symptoms" section appears repeatedly.

↑ Back to the top

References

For more information about charts, click Microsoft Excel Help on the Help menu, type create a chart in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

↑ Back to the top

Keywords: KB211953, kbprb, kberrmsg, kbchart

↑ Back to the top

Article Info
Article ID : 211953
Revision : 5
Created on : 11/5/2003
Published on : 11/5/2003
Exists online : False
Views : 226