Excel macros run out of memory in Windows Vista

[horsepro001]

Please help. My new Dell laptop came with Windows Vista. I transferred some
Excel 2002 spreadsheets from my Windows XP desktop computer (also a Dell) to
my
new laptop. My laptop has Excel 2007.

Those spreadsheets were created in Windows XP and, though voluminous (20
megs each), run fast and perfectly in XP. Now, on my laptop, they can't even
finish their processing due to running out of memory. My laptop has three
gigs of RAM whereas my 5-year-old desktop has only 512k.

How can I get my macros to fully run within my laptop? Thank you very much,
in advance.

 

[sgopus]

I think your going to find there is a compatablilty issue between office 2002
and office 2007 I've heard there are problems but not sure of details.

 

[measekite]

Go to office updates, there you will find an update that will fix the
compatibility issue.
Frank

You mean Microsoft software has trouble with compatibility and the
wonderful vista.

 

[John]

See if you can set the excel.exe to run in XP Compatibility mode...
Properties--Compatibility.