Microsoft KB Archive/31179

{| = Excel: Closed Worksheet Number Formats Do Not Appear on Chart =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q31179

SUMMARY
The format of values on a chart will update only if the supporting worksheet is open. If the worksheet is closed, the values will appear on the chart but the formats will not update.

Worksheets linked to other worksheets do not transfer formats. The information will always display according to the format applied to the dependent worksheet; it does not matter whether the supporting worksheet is open or closed.
 * }