I have an Excel application that has three sheets Data, Work area, and display.
Data = Data Work area = Formulas Display = Charts.

When I change the name of the Data sheet the work area update ok but the
chart does not display any data.