Memory utilization shoots up in excel 2007

Dhans

New Member
Joined
Nov 7, 2008
Messages
5
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.
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

random_noise

Active Member
Joined
Dec 19, 2007
Messages
367
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)
 

Watch MrExcel Video

Forum statistics

Threads
1,095,781
Messages
5,446,462
Members
405,403
Latest member
horace james

This Week's Hot Topics

Top