Well, if you get a chance, try safe mode. I know you _think_ they're the
same but they are not.
--
Jim
"(e-mail address removed)"
| 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
| > "(e-mail address removed)"
| > | > | 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
| > | > "(e-mail address removed)"
| > | > | > | > |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
| > | >
| > | >
| > | >
| >
| >
| >