Avatar of hydrazi
hydrazi
 asked on

Excel 2003 files with Macros slow to open

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.  
Microsoft ExcelWindows XPNetworking

Avatar of undefined
Last Comment
yobri

8/22/2022 - Mon
Matt Coughlin

I have seen security software such as antivirus programs scan excel files with macros if they are stored on a network server.
hydrazi

ASKER
just tried disabling antivirus, it had no effect.  Good idea though.
ASKER CERTIFIED SOLUTION
yobri

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy