I currently have a workbook that has several macros. One function I run
copies and pastes special-values certain formulas, maybe 100-200 times, and
also updates links to other workbooks. THe computer I run this on is a 64
bit processor, but it takes a minute or 2 to run the function. I recently
tried this on a separate 64 bit computer and it took 2 seconds. I checked
the settings and calculation is on automatic for both machines, and the other
settings I checked also matched. Both machines also have the same amount of
hard drive available, about 70 GB. Is there any reason for the differences
in run time between the two systems?

Thanks

Adam Bush