My team and I have developed and run many macros throughout our workday, some
of which can take up to a couple of hours. The bulk of the slow processing
seems to be with vlookups and sumproducts on 20K - 30K rows. We're currently
on systems with 3 Ghz processors, 2 GB RAM, and 40 GB hard drives. I checked
the virtual memory and windows has it set to 1,500 MB. I've read that Excel
2003 maxes out at a virtual memory of 1,024 MB, so will upgrading our PCs to
4 GB RAM with 80 GB hard drives increase throughput? Or is the upgrade not
cost effective due to Excel's limitations? If there is a benefit is there a
way to gauge it based on the old/new system specs? Additionally please note
that we typically have very few other applications open, ie. MS Outlook 2003
and/or Oracle - TOAD.

Hi,

I doubt a PC upgrade will make a significant amount of difference but there
are some coding techniques that will give benefit and the 2 big ones are

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

your code

Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic

Mike

"PoolMaster" wrote:

My team and I have developed and run many macros throughout our workday, some
of which can take up to a couple of hours. The bulk of the slow processing
seems to be with vlookups and sumproducts on 20K - 30K rows. We're currently
on systems with 3 Ghz processors, 2 GB RAM, and 40 GB hard drives. I checked
the virtual memory and windows has it set to 1,500 MB. I've read that Excel
2003 maxes out at a virtual memory of 1,024 MB, so will upgrading our PCs to
4 GB RAM with 80 GB hard drives increase throughput? Or is the upgrade not
cost effective due to Excel's limitations? If there is a benefit is there a
way to gauge it based on the old/new system specs? Additionally please note
that we typically have very few other applications open, ie. MS Outlook 2003
and/or Oracle - TOAD.

Typically hardware does not get you much further ahead... check out this link
for many helpful suggestions...

http://www.decisionmodels.com/index.htm
--
HTH...

Jim Thomlinson


"PoolMaster" wrote:

My team and I have developed and run many macros throughout our workday, some
of which can take up to a couple of hours. The bulk of the slow processing
seems to be with vlookups and sumproducts on 20K - 30K rows. We're currently
on systems with 3 Ghz processors, 2 GB RAM, and 40 GB hard drives. I checked
the virtual memory and windows has it set to 1,500 MB. I've read that Excel
2003 maxes out at a virtual memory of 1,024 MB, so will upgrading our PCs to
4 GB RAM with 80 GB hard drives increase throughput? Or is the upgrade not
cost effective due to Excel's limitations? If there is a benefit is there a
way to gauge it based on the old/new system specs? Additionally please note
that we typically have very few other applications open, ie. MS Outlook 2003
and/or Oracle - TOAD.