asked on

out of ram on excel

Anyone have a work around for office 365 randomly tell you. you do not have enough ram and suggest you to install 64 bit. even when you have install 64 bit it still tells you that. Have try repairing the office brand new install. File that user was trying to open was less than 5 MB and ram usage is less than 5GB. the computer has 16GB of ram so do not think it is a hardware limitation and also virtual ram is set at 24 GB the maximum the system recommend. Any suggestion would be much appreciated. (also login and out office 365 does not work to this problem). Video graphic aceleration is also turn off on excel. once you error prompt you need to force close excel. the next time it opens it will open normally with the same files without the error of out of ram.

best regards

John

Dr. Klahn

Sounds like either

a) There's a memory leak in your application (I think this is more probable)
b) Excel is not garbage collecting properly (certainly a possibility as well)

https://social.msdn.microsoft.com/Forums/vstudio/en-US/163ff3e5-482a-4201-a722-abd06f0e0f91/excels-slow-garbage-collection?forum=exceldev

http://ramblings.mcpher.com/Home/excelquirks/snippets/scope/garbage

If it's case (a), then walk through your application, check the memory usage at every stage, and find out where the memory is being lost.

If it's case (b), then there's not much that can be done other than pause occasionally and hope that Excel does a garbage collect.

John

ASKER

Thank you for your feedback but available ram at the time of the problem was about 24GB and usage was about 5 GB in performance. so even if it was leaking it should have ram usage at 100% but that was not the case. 64 bit office should be able to use all of the virtual ram (64bit can use upto 8TB worth of virtual ram).

best regards

John

This question needs an answer!

Become an EE member today

7 DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform.

View membership options

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.