In one spreadsheet, I have a dynamic chart where the x axis is a named
dynamic range (so that it automatically advances by a month, every month).
This works fine.

However, I have copied the graph to another spreadsheet where it is useful
to be displayed. All is fine if both spreadsheets are open. However, if I
open the second one without the first being open, the x axis is incorrectly
displayed and an error message comes up saying that the named range
("xaxis") cannot be found on the first spreadsheet. If I then open the
first spreadsheet, everything appears correctly once again.

Can anyone suggest how I can overcome this please.

TIA

V