Very frustrating. Yes, I'm selecting 'calculating sheet', and all 5-6 open workbooks are in manual calculation mode, yet Excel calculates all open workbooks.
The only fix I've found so far is rebooting. I'm guessing I'm building up lots of cache (working with a large file with lots of VBA code) that is affecting Excel because I've seen odd behavior in various programs over the years when cache builds up.
Appreciate any help/ideas.
The only fix I've found so far is rebooting. I'm guessing I'm building up lots of cache (working with a large file with lots of VBA code) that is affecting Excel because I've seen odd behavior in various programs over the years when cache builds up.
Appreciate any help/ideas.
