Dynamic Named Ranges
 

I have a chart which displays 30 days worth of data at a time, linked
to another workbook. I am charting a dynamic named range in the source
file however my chart data disappears every time source workbook is
closed (not cool!) need a way around this without using macros..
Apprceiate any help