troubleshooting Question

Excel 2003 files with Macros slow to open

Avatar of hydrazi
hydrazi asked on
NetworkingWindows XPMicrosoft Excel
3 Comments1 Solution478 ViewsLast Modified:
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.  
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros