Avatar of Usman Farid
Usman Farid
 asked on

Running out of memoery Excel 2010

Hi,

A user who uses excel a lot, has few different excel files opened. When they try to move data from one spreadsheet to another, it gives an error that "excel is running out of memory", and it does not let the user complete the task.

I have checked com add ins, nothing unusual running.

Is there anything which can be done to resolve this?

Thank you
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Ramin

8/22/2022 - Mon
Ramin

How much RAM is on that PC ?
CES

Which architecture are you running of MS Office?  If 32-bit, can you reinstall the 64-bit version?
Usman Farid

ASKER
Hi,

4gb Ram

and its 32 Bit Excel, I know that 64 bit allows more memory usage, but I guess I wont make that call of installing 64 bit ver.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER CERTIFIED SOLUTION
Ramin

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Martin Liss

Try turning automatic calculation off before transferring the data.
Usman Farid

ASKER
Issue resolved.
Ramin

I'm glad we could help.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.