Chart using dynamic (offset) named ranges gets set to "static" data referenced on re-open

So I have some fancy chart that covers a dynamic range using named ranges + offset() functions.  Certainly these are some of the things that strain the limits of excel without entering the abyss that...