I have two excel files, one is the data and the other the graphs. All the graphs are linked to cells in the data file. I have changed the security settings to update the graphs automatically. When I open the graphs file though, my horizontal axis labels don't appear. The data in the graphs have been updated but the horizontal axis is blank. I have to open the data file for the labels to appear?