Microsoft KB Archive/33244

{| = Excel Err Msg: Can't Save If Dependent Sheet Refers to Old... =
 * width="100%"|

Last reviewed: October 31, 1994

Article ID: Q33244

SUMMARY
The alert &quot;Can't save if dependent sheet refers to old and new names&quot; will display if you try to save a supporting worksheet with a new document name that is already being used by a dependent worksheet that is open.

To work around this problem, do one of the following:

  Close the dependent worksheet, then save the supporting worksheet. -or-  Remove the external references from the dependent document, then save the supporting worksheet.

Note: this may also occur when the dependent sheet is a chart.
 * }