The ability to turn off the ram limit in excel
I have a system with 32gb of ram and I have a pretty large spreadsheet and when I try to accomplish or make changes I always get a memory error. I know excel isn't using all my ram and I can see that clearly in task manager. If I have 32gb of ram I should be able to utilize it to its fullest potential.
Michael Daughety commented
I have a 3.2GB spreadsheet with over a billion cells populated and haven't actually found a limit yet using Office x64
Charles Williams commented
@Samk - could you try downloading and using my ShowMemory tool?
Thanks for the quick response Thomas, but I checked in the about dialogue in excel and it says that it's 64 bit.
Thomas K commented
You need to use the 64 bit edition of office, that can perhaps solve your ram issues.