Graphs not updating when data changes

[sobrien1234]

I have a workbook that looksup values and does reports and has some graphs in it. The graphs used to automatically update when I change the record number of each file. Now it doesn't. It only works if I chnage the record then save the file then re-open it.

Help please!!

 

[Michael M]

Not sure if this matters in this situation, but do you have the formula calculation set to automatic? Go to the Formula tab and, on the far right, click Calculation Options and make sure the check-mark is next to Automatic.
If that doesn't work you could also try rebooting the entire PC.

 

[sobrien1234]

Not sure if this matters in this situation, but do you have the formula calculation set to automatic? Go to the Formula tab and, on the far right, click Calculation Options and make sure the check-mark is next to Automatic.
If that doesn't work you could also try rebooting the entire PC.

Yeah it's already on automatic. Tried shutting down as well??

 

[Michael M]

Is the data changed via a macro ?

 

[sobrien1234]

Is the data changed via a macro ?

Yep - just changes the number to lookup by 1.

 

[Michael M]

Can you post the code please ?

 

[Masum Mahdy]

Excel Chart Not Updating with New Data (2 Suitable Solutions)

This article illustrates 2 suitable solutions of Excel Chart Not Updating with New Data issue. Read it wholly, and enjoy learning with us!

www.exceldemy.com

Check this out!