Excel and Ram

ravisolanki79

New Member
Joined
Aug 27, 2010
Messages
4
Hi,
I am currently using a Lenovo machine which runs of win 7 32 bit , excel 2010 32 bit. I always use to get speed related issues and the IT said that I need to move to a 64 bit OS with higher Ram. Before switching to the higher Ram I decided to do a speed test and for this test I am using a Lenovo ThinkPad, Core i5 Vpro processor on 64 bit Win 7 and office is 2010 (64 bit, trial version) and the RAM on this machine is 8 GB.

The issue is that when I run heavy excel files on this machine the CPU utilization goes upto 100% but the machine is not using a more than 1.8 GB of ram. The remaining RAM shows available. Is there a way that I can force Excel to use my spare Ram and so that I can speed-up the processing power.
Just to let you know for this speed test I created a file on win 7 (32 bit) machine using 32 bit excel 2010 and now I am running this file on the machine with higher configuration.

Any help on this will be much appreciated.
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Forum statistics

Threads
1,214,985
Messages
6,122,605
Members
449,089
Latest member
Motoracer88

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top