View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default 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