I have been pasting data into an Excel chart every month for 10 years. Now it looks like no pasting has happened since the 10 years passed. Could it be that some time limit is being applied to my Workbook ?
I have been pasting data into an Excel chart every month for 10 years. Now it looks like no pasting has happened since the 10 years passed. Could it be that some time limit is being applied to my Workbook ?
This reminds me of the question how long one may park on a motorway lay-by. The answer is as long as the vehicle registration remains valid (because a vehicle without valid registration isn't permitted on the motorway of which the lay-by is a part).
No, nothing in Excel prevents data from being updated. But over the period of 10 years there have been changes to Excel. It seems like you are talking of an automated process and the macro written a decade ago may contain code no longer understood. The answer to your riddle must be looked for in the process.
Or look at the interpretation of the data in the chart. It may be designed to read data of a range limited to 120 rows. That may have seemed plenty 10 years ago but now the new data added at the bottom just aren't included in the chart any longer.