Reference not Valid, must be to an open worksheet

[JessicaLou]

Hi

I'm trying to make a chart using named ranges, and when I try to add a series, I get the error 'Reference is not valid. Reference must be to an open worksheet.'

I have searched the problem and done everything suggested:
- I am typing it in correctly
- All named ranged are within the workbook, not an external file
- I have tried to break the links to other workbooks, 2 won't go when I break links
- Removed data validation that might refer to another workbook
- Removed conditional formatting that might refer to another workbook
- Searched for '.xl' within formulas and deleted all results

All in all I don't understand a) where the links are, or b) why their existence means I can't make the chart.

Any help would be great, thank you!

 

[RoryA]

What named ranges are you trying to use - how are they defined?

 

[JessicaLou]

What named ranges are you trying to use - how are they defined?

Hi Rory, thanks for responding

They're using OFFSET, with a COUNT in there to determine how many columns to include

 

[RoryA]

We need the actual formulas to be able to tell you why they don't work.