Good morning,

I have a workbook that I am using as a dashboard for multiple business lines. Within the dashboard I have a budget section. One sheet contains graphs of three different funding organizations, showing approved vs YTD budget. The data from these graphs comes from a different worksheet stored on the same server but different location. When I open the data spreadsheet directly from the server the graphs will update accordingly. However, I also have a link on each graph that will open the appropriate data spreadsheet. If changes are made to the data spreadsheet when opening from the link, and saving to the same location, the graphical data will not change. It will only update if I go back and open the data spreadsheet from the server itself. I only have to open the spreadsheet for the graphical to update. I don't have to change anything.

What is the cause of this and is there a solution to fix?