Running out of memoery Excel 2010

Usman Farid
Usman Farid used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
RaminTechnical Advisor

Commented:
How much RAM is on that PC ?
CESNetwork Administrator

Commented:
Which architecture are you running of MS Office?  If 32-bit, can you reinstall the 64-bit version?
Usman FaridService Desk Analyst

Author

Commented:
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.
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Technical Advisor
Commented:
If you need to work with large files then open fewer files at once or install the 64 bit version of Office or install more RAM.
that is the limitation of 32 bit version .

More Details:
https://support.microsoft.com/en-us/help/2779852/how-to-troubleshoot-available-resources-errors-in-excel
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Try turning automatic calculation off before transferring the data.
Usman FaridService Desk Analyst

Author

Commented:
Issue resolved.
RaminTechnical Advisor

Commented:
I'm glad we could help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial