View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mfleet1973@yahoo.ca is offline
external usenet poster
 
Posts: 2
Default Excel Experts Needed: Marcors on Shared Documents are slow....

Hi.

A collegue of mine created a macro which works very fast (about 30
seconds) when the Workbook is not shared. However, when the Workbook
is shared, the same Macro takes up to 20 minutes. The Workbook is on
the local drive.

Why would a macro take longer to run when the workbook is shared?

Thanks a lot for any replies!

Mike.