Manual vs. Automatic Calculation Speed
Thnaks for the replies guys,
The machines are both using just one add in, and they are identical. They
both also have the same antivirus software. Could I have a setting other
than calculation different on the machines? Any other ideas?
Thanks
Adam Bush
"Jim Rech" wrote:
It doesn't make much sense that the same macro in the same workbook on near
identical machines should run at speeds so different. The only thing I can
think of is that the slow machine has something else running (in Excel). If
you start Excel on the slow machine in safe mode (from Start-Run enter
"Excel.exe /s" [no quotes, there is a space before the slash]) then you'll
be certain no add-ins, etc. were loaded and then you might see how the macro
does.
--
Jim
"
m wrote in message
...
| 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
|
|
|
|