Excel 2007 Graphs do not update automatically

[iamrai_]

Hi,
My excel calculation is set to manual, but even if the cells calculate after I hit F9 or save the file, the graphs plotted from my data sets do not update with the new values. This only occurred today and as a temporary solution, I close and re-open the file for the graphs to update. What seems to be the problem here?

Hoping for your help.

Thanks,
Rai

 

[Derek Brown]

Hello and welcome to The Board.
Do you have any User Defined Functions (UDFs)?
Have you tried forcing a FULL recalculation using Ctrl + Shift + F9 ?
Have a look at:
http://www.ozgrid.com/forum/showthread.php?t=40636