I have made a chart and it is fed from a dynamic name range. The named range basically is an offset function that returns a range based on cell references with dates in. But anyway, When I apply it to my chart the series value looks like this:
=Gas_Dashboard!Gas_Spend_Dynamic
Where Gas_Dashboard! is the name of my sheet and Gas_Spend_Dynamic is my named range. I know it works, I have another for the labels and it all works fine. However, whenever I save my document then close it when I come back my named range looks like this:
=[0]!Gas_Spend_Dynamic
Why is it resetting my worksheet to [0]!? Do I need to select an option or something? I am using Excel 2007.