David_ON

While working with large(ish) spreadsheets, I frequently get "insufficient resources" errors in 32bit Excel 2013. I'm about to upgrade to Office 2016 - would my laptop's 4GB be enough to gain at least some advantage from 64bit Excel? Thanks!

Hi, folks! After decades of using Excel, the two items below still trip me up. I appreciate that they were deliberate choices by the Team, but I've never been able to see the reason why. Can you give me an explanation, please?

(1) Knowing when Calculation is not happening automatically is obviously critical. But the "CALCULATE" indicator in the status bar can be overriden by significantly less important messages (e.g. "Select destination and press ENTER or choose Paste").

(2) When the "Find and Replace" dialogue is displayed, the focus may be in either the "Find what" or "Replace with" field (depending on whether "Find what" is empty?). This means that after <Ctrl-H>, one has to check where the focus is, perhaps move it and only then start entering details. If "Find what" was always the focus, then us non-touch typists could simply type "<Ctrl-H>old<Tab>new", only then looking up to check all is correct and hit <Enter>.

Thanks for your time,

David.

Thanks, BVW, but that requires the user to take some action, whereas being able to see "CALCULATE" on the Status Bar doesn't.

Thanks, BVW! My issue is more around recognising that Calculation has gone manual than turning it on again.