Manual vs. Automatic Calculation Speed
 

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

Manual vs. Automatic Calculation Speed
 

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

Manual vs. Automatic Calculation Speed
 

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

Manual vs. Automatic Calculation Speed
 

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
|
|
|

Manual vs. Automatic Calculation Speed
 

Is the Anti-virus the same on both?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"
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

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
|
|
|

Manual vs. Automatic Calculation Speed
 

Well, if you get a chance, try safe mode. I know you _think_ they're the
same but they are not.

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

Manual vs. Automatic Calculation Speed
 

Jim,

Thank you very much for the tips. It ends up the difference in the two
machines had to do with an add in they both had. The add in has a setting
which recalculates EVERY formula in the workbook, including ones that aren't
effected, whenever a cell is changed. One machine had this setting on, one
had it off. Since I have thousands of formulas in the workbook, you can see
how this would slow things down.

Thanks

Adam Bush


"Jim Rech" wrote:

Well, if you get a chance, try safe mode. I know you _think_ they're the
same but they are not.

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