Excel 2003 very slow to open files on network

Was this reply helpful? Yes No. Sorry this didn't help. Thanks for your feedback. Roget Luo. Anything over kbs is taking roughly seconds to open, anything above 1mb is causing Excel to crash. Search forums. Log in. Sign up. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations.

Click here to join today! JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding. Solved Word, Excel slow opening over network since windows update. Thread starter ozegirl Start date Jul 11, Status This thread has been Locked and is not open to further replies.

The original thread starter may use the Report button to request it be reopened but anyone else with a similar issue should start a New Thread. Watch our Welcome Guide to learn how to use this site. Joined Jun 21, Messages Did Windows update last night on 2 Windows 7 computers. This morning, I can still access Word, Excel and Access documents from Computer 1 of files that are resident on Computer 2 via a mapped network drive. However they take an exceedingly long time to open, the splash screen comes up with Contacting..

It's Office on both computers and this morning I updated Office on both thinking this might be the issue and the solution. But still the same. I can open non-Office documents via the network drive instantly. Office documents open on both machines locally fine. It's just Office documents via the network. There is no network issue because I can access the drive quickly and open other files quickly. I this should help you narrow down where the slow-downs happen.

Bruce E OP should probably also check the server and network load. Charging your smartphone overnight can damage the battery and shorten its lifespan. Here's everything you need to know.

Jan F. That's hard to say without knowing the full infrastructure. Here's an example of a timer function that shows how long a module takes to run. If you have one large module, then place timers in different locations of the module. This will strip out the Macros. Open the saved file and see how long it takes top open. If it opens quickly, the problem is with one of the macros. It will look like this:.

Start there; feed back. I guess it could be a couple things. You need to assign that to a dynamic named range that truncates the range to the lowest row with data. Verify that the file has not been corrupted and that the file extension mateches the format of the file". I've done this thousands and thousands and thousands of times. I've never seen that happen.

How can Excel not recognize one of it's own files??? I'm not sure what you mean. Excel will open any file. I can see where wouldn't open a or file, but there is an update that you can download to get the older Excel to open files produced by newer Excel versions. Long story short, it's probably time to upgrade from That technology is 10 years old.

In the world of software, 10 years is a looonnnnnngggggg time. The issue that we are seeing here is we have excel version file, which is being tried to open in version and it is opening by taking lot of time more than 30mins but the same same file is opening in version within a min.