Dear community,
I realized that Excel had a memory error on the computer given to me at my new workplace, and that there was a 32-bit installation. Excel took minutes to apply the formulas and sometimes even stopped responding. As a solution, I installed 64 bit Excel with great expectations and difficulties. But now I can't get the performance I want. While Excel is fully loaded on 12 cores (more than %96), it only takes a bite out of the RAM, 2GB at most. I have seen some friends having the same problem in community. I leave infrastructure information and steps I have followed so far below. Thank you very much in advance for your support.
Disabled hardware graphics acceleration
Enabled multi threaded calculation
Operating System Name Microsoft Windows 10 Pro
System Type x64-based PC
Processor 12th Gen Intel(R) Core(TM) i7-1255U, 1700 Mhz, 10 Cores, 12 Logic Processors
Installed Physical Memory (RAM) 16.0 GB
Available Physical Memory 7.69 GB
Paging File Space 2.38 GB
Model SAMSUNG MZVLQ512HBLU-00BH1 SSD 512gb
Microsoft® Excel® LTSC MSO (16.0.14332.20714) 64-bit
I realized that Excel had a memory error on the computer given to me at my new workplace, and that there was a 32-bit installation. Excel took minutes to apply the formulas and sometimes even stopped responding. As a solution, I installed 64 bit Excel with great expectations and difficulties. But now I can't get the performance I want. While Excel is fully loaded on 12 cores (more than %96), it only takes a bite out of the RAM, 2GB at most. I have seen some friends having the same problem in community. I leave infrastructure information and steps I have followed so far below. Thank you very much in advance for your support.
Disabled hardware graphics acceleration
Enabled multi threaded calculation
Operating System Name Microsoft Windows 10 Pro
System Type x64-based PC
Processor 12th Gen Intel(R) Core(TM) i7-1255U, 1700 Mhz, 10 Cores, 12 Logic Processors
Installed Physical Memory (RAM) 16.0 GB
Available Physical Memory 7.69 GB
Paging File Space 2.38 GB
Model SAMSUNG MZVLQ512HBLU-00BH1 SSD 512gb
Microsoft® Excel® LTSC MSO (16.0.14332.20714) 64-bit