I had a compaq 450 spx?? 1.6 GHz P4, 512MB Ram, XP w/ Office 2002 that I used to run a VBA heavy spreadsheet (pulled data from website using Web Query) and did some manipulation of the data. The spreadsheet cycled through 3,000 iterations so it took about 45minutes to run using my cable modem connection.

I thought if I upgraded to a Dell Inspiron 1501 AMD 1.8 GHz Turion L-56 processor, 1GB RAM, XP Media Center 2005, Office 2003, the performance would be a little better (believing the internet connection would be limiting factor). In any event, the file would take longer to open, then it took literally 1-2 seconds for the cursor to jump from one cell to the next. And running the VBA code was into the hours! It's impossible to work with the file with the given performance.

Exact same file, two separate computers. Is there an obvious reason for this degredation? Memory type? Excel defaults? AMD vs Intel processor?

any advice is greatly appreciated.