Excessive use of memory even for simple operations
I have tried to isolate the issue, but I couldn't find one exact scenario that I can link to this problem: Excel starts using memory at galloping speed when doing simple operations such as remove or insert a row.
I am using a 2017 MacBook Pro 13, Macos High Sierra and I have the latest Office 2016 updates. I did a fresh install.
I suspected the conditional formatting is an issue (which it is another problem because you cannot format fonts on Mac). I removed all formatting, yet I have the same problem. It seems that Excel is using the clipboard to do operations because when I exit (after minutes of waiting) I am asked if i want to keep the large amount of data on the clipboard, although I haven't used it).
It is immensely frustrating. After decades of software development it is inconceivable when get this kind of problems. I am appealing for a quick resolution.
excel on my late 2016 MacBook Pro is using huge amounts of memory. all I'm doing is simple data entry. After opening an online version of excel, I elect to edit it in my copy of excel. It starts out using 150 MB of memory, but then gradually increasing its use of memory until its over 2 GB if I let it go that far. But long before it's using 1 GB, it's generally taking minutes of being unresponsive before I can do anything, so I'm just sitting waiting for it to catch up! I have tried setting autosave to every minute instead of the default 10 minutes, because there have been a number of times where I've lost hours of work, because it was "saving" but never really saving! I'm pretty disgusted with its total lack of performance!
23rd august and exactly the same issue... stalling and a lot of processor use up to 60% just scrolling up and down the excel.... wTF is happening... i have also used conditional coloured formatting .
and i also object to being forced to I agree to the storage of my email address, name, and IP address. This information and any feedback I provide may be used to inform product decisions and to notify me about product updates.!!!!.