Excel - problem

Question

Hello,I have a problem with Excel 2019. Computer i7 16GB RAM and very often I have the message that "Not enough memory to finish this action"What can you do about it?

nauthstar · Answer

I had memory problems (crashing, Hanging and memory error messages) until I switched to the 64 bit version of Excel. Make sure you have a 64 bit version of Excel loaded.

gregjas · Answer

The easiest way to check which version of Excel (32.64 Bit) is?Nauthstar&nbsp;

nauthstar · Answer

GregJas&nbsp;Open Excel, go to File --&gt; Account --&gt; Manage Account.

gregjas · Answer

Thank you very much, however, I have 32Bit. Will I be able to install 64Bit versions on my legal license (key)?Nauthstar&nbsp;&nbsp;Regards.

nauthstar · Answer

GregJas&nbsp;&nbsp;Check that you have Windows 64 bit.&nbsp; Usually found&nbsp; using START --&gt; SETTINGS --&gt; SYSTEM --&gt; ABOUT.&nbsp;&nbsp;It should give you the screen attached - See picture.&nbsp;&nbsp;If that is 64 Bit then you should be able to go in to Excel, make sure all other Microsoft products are closed, then from Excel you should be able to select FILE --&gt; ABOUT --&gt; MANAGE ACCOUNT.&nbsp;&nbsp;It should give you the option to INSTALL OFFICE.&nbsp; Choose this option.&nbsp; If your licence does not permit this (because it's a standalone version?) then you won't be able to go any further.&nbsp; However, it should permit it as you can't run both versions on the same pc/laptop.&nbsp; Therefore, you should be able to load (or reload) MS Office 32 bit or replace it with the 64 bit version.&nbsp;Choose 64 bit and it will automatically download and install the 64 bit version (or give instructions for replacing the 32 bit version by removing that version first)&nbsp; Once complete, all your existing files will open and you won't have any more memory errors.&nbsp; &nbsp;PS Make sure you take a copy of your Excel files onto OneDrive or some other place on your hard drive.&nbsp;&nbsp;

Forum Discussion

Excel - problem

7 Replies

Resources