Macros failing due to failure to refresh formulas

[peftypefty]

I have several macros which have run fine for months but have suddenly stopped functioning correctly. By stepping through them I have found that the problems always crop up due to Excel's failure to refresh cells containing formulas. If this refresh failure happens in the middle of a macro, I think it's easy to see how it could screw up the functioning of the rest of the macro.

My question: Aside from inserting a "Save" command at every other line of code in the macro, is there any way in VBA to force Excel to refresh formula values across the board? And more broadly, is there some parameter in Excel or in Windows that I can change in order to encourage Excel to do a better job refreshing on a regular basis?

Do I simply need more RAM?

Help would be greatly appreciated.

 

[tusharm]

Have you checked the calcuation setting for XL? It appears someone changed it to something other than automatic. Check Tools | Options... | Calculation tab.

 

[peftypefty]

Thanks so much tusharm!
That was easier than I'd hoped................

 

[tusharm]

You are welcome. Glad to be of help.