Hi

I have created a dynamic chart that updates as I select the date range from a drop down menu.

Each data series in my chart refers to a named range in my worksheet - the named range is a formula that updates the data range as the drop down is changed

It works perfectly well - except when I close the worksheet and then re-open it the named range referred to in the axis label range has changed slightly so that it no longer works.

For example - what it should look like when it works:

=Parameters!mydates
The workbook is called: QuoteCalcs.xlms
The sheet within the workbook: Parameters

When I close the worksheet and then reopen it the code changes to the below.

=[0]!mydatesmj
I have to then manually change [0] to Parameters to get them all to work which defeats the whole purpose

I am not sure if I need to fix the Parameters sheet within the code - not sure how to do this??

Any thoughts/comments much appreciated?

I have also posted this on mrexcel but the suggestion I received didnt work