Memory utilization shoots up in excel 2007

[Dhans]

Greetings to all.. We have developed an application in Excel 2003. Now we are accessing the same application through Excel 2007. When we do some operations it utilize around 2gb of system memory and the Excel get hanged.

Did anyone came across this issue while working with excel 2007. Please help me in this to overcome this situation. Thanks in advance.

~Dhans.

 

[random_noise]

I have found that in general 2007 does use a lot more memory than 2003.

It may be that your code needs to be optimised slightly. It may have worked ok in 2003 because it was more forgiving, but in 2007 you have to make sure everything runs in the most efficient way possible.

A macro I created used to take about 30 seconds in 2003 & in 2007 took about 15 mins!

Are you doing things like turning off screen updating & calculations etc while running your code?

It would help if you posted your code here if you can to allow people to see if you can run anything in a more efficient manner.

Please use code tags then posting (use the # button on the reply screen)