So I have a computer with 3.45 GB of RAM according to my OS (XP). I have 2 GB virtual RAM.
My company pushes Excel to its limits of referencing other worksheets which eats up a lot of resources. Often times when it is running calculations, saving, etc the program will appear to hang for sometimes as much as 10 minutes.
When looking to see what the issue is I notice the processor is usually running at about 8-12% but the RAM is usually 250,000+ KB. This causes my computer to run slowly which would make sense to me if I only had 512 or maybe a Gigabyte of RAM. I know that 250,000 is quite a bit of memory to be used for the OS, but having a total of 6 GB, I would expect much better performance.
Is there an explanation as to why it would run so slow?
edit: I should clarify. I'm looking for more of the concept behind this not just a solution to my computer running slowly (that was just supposed to be an example). I was under the perception that I should be able to use nearly all my RAM before noticing serious speed changes that would affect my whole system.