excel graphs won't update
 

I have a large spreadsheet (50 MB) and when I update variables in the
calculations the graphs will not update. All of the calculations in the
workbook are correct and the calculations update immediately but the graphs
appear to be frozen. If I save the changes, close the spreadsheet and then
re-open the graphs are updated perfectly. Anyway to get the graphs to update?