Hello,

Recently I began a new job and am using an Excel sheet template created by a past employee. In this template there are 14 sheets containing charts. The charts display the storm water flow height for each location along one y-axis with the rain data shown along the adjacent y-axis. Clean versions of the templates are kept and the data is changed every month. Monthly rain data is imported into a Rain Data sheet in the same book as the chart sheets. I "Get External Data" from a Text file. When I copy and paste the rain data, the charts from the other sheets don't update the rain data, but do update the flow heights.

When I click on the cells, they are in a general number format. All of the charts have the correct series values and I have even tried to manually select the data by clicking the column, but the charts still don't update.

If anyone has any advice it would be greatly appreciated.

Thank you,

Jay