Jim,

The workbooks my spreadsheet is linked to are always closed on the computer
in which I'm running the function. It seems as though the updating links
have nothing to do with it, and that the copying and pasting are whats
slowing the one computer down. Any ideas?

Thanks

Adam Bush

"Jim Rech" wrote:

First I'd try to see if the performance different is due to the copying or
the link updating. Comment out the code that does the latter to see if the
slow machine is now fast (which I sort of expect). If it is the linking
then why would that be? Are the workbooks being linked to open on the fast
link machine versus closed on the slow? Are they on a more accessible
machine?

--
Jim
"
m wrote in message
...
|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