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