Excel 2003 files with Macros slow to open

hydrazi
hydrazi used Ask the Experts™
on
I have a client with a simple file server and 2 workstations running XP.  His file server has a few folders with only Word and Excel files.  One workstation (they are virtually identical) has no issues.  The other can open Word files super fast, even if they are over 1mb.  Same with some Excel files...... except:

When the Excel files have macros inside of them, it has started (as of the last week) to take 20 seconds or more to open the file.

I tried changing the OPEN for the file type to manual and then back to DDE, no change.  I have tried opening Excel first and browing for the file, no difference.

IF I move the Excel file to the desktop and open it, it's super fast!  So it has something to do with the Macros and being on the Network.  I am stumped.  
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I have seen security software such as antivirus programs scan excel files with macros if they are stored on a network server.

Author

Commented:
just tried disabling antivirus, it had no effect.  Good idea though.
Top Expert 2011
Commented:
It is quite possible that a rather recent update is the cause of this issue. See the MS KB about this.

http://support.microsoft.com/kb/2570623

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial