ExcelBanter - changing name of data sheet in a application

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - changing name of data sheet in a application (https://www.excelbanter.com/new-users-excel/190840-changing-name-data-sheet-application.html)

Octet32

changing name of data sheet in a application

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.

All times are GMT +1. The time now is 11:51 PM.