Linking graphs to other spreadsheets
 

Hello All,

I have two seperate workbooks, one of the two has graphs that pull data from
the other file. If I only open the file with graphs, the data in the graph is
accurate, but the axis on the bottom is not accurate (The bottom is a date
format) If I open both files and then look at the graphs, the axis looks
proper. Is there a way to link the files that I don't have to have both open
to look at the graphs?
--
Thank you for your time!
John