I am trying to reduce the stored EXCEL memory that is shown in the task manager.
Only one file is loaded and memory for Excel is shown as 1.35 GB yet in file explorer the file size is only 230 MB ?
How can that be ?
I opened a second instance of Excel and copied the entire sheet to it to see if there had been any stored settings
and that made no difference.
I am hugely disappointed in Microsoft limiting Excel to only 2GB and wonder if this might be addressed in new version this year.
Any assistance much appreciated