Solved

Shared spreadsheet slow over network

Posted on 2011-09-14
3
406 Views
Last Modified: 2012-05-12
We have a client who is trying to open a shared excel document, however it can take over 3 mins to open from the network location on her PC, other users can open the document fine from different PC's and when the document is copied locally to the desktop it also opens fine.

All other excel documents that are saved on network locations open fine, even ones that are considerablly larger, it is just the one document that is affected.

We have tried to do an open and repair on the file which makes it open instantly however when opening normally the file will still take 3 mins or more to open.

We have also done a repair install of office.

The affected PC is a fully patched Windows XP PC running Office 2003.
0
Comment
Question by:markkindred
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 77

Accepted Solution

by:
Rob Williams earned 500 total points
ID: 36535605
A few possible causes::

This issue has become common recently with Office 2003 files:
http://support.microsoft.com/kb/2570623
http://technet.microsoft.com/en-us/security/advisory/2501584

Some people have reported opening Excel files on a network share can be delayed due to updates: KB2541025, KB2502786, KB2509503
On the one I encountered I only had to remove the first update

Slow opening of files, especially Office files, is often related to Windows searching for old links that no longer exist. Finding these can sometimes be a bit time consuming. A few places to look:
-Network places. Look for links/connections that no longer exist.
  (I prefer to also turn off "automatically search for network folders and printers". Locate by going to the menu bar of my computer | tools | folder options | View | fist item)
-My computer. Look for mapped drives that are disconnected.
-Start menu "recent Documents". To clear; right click on task bar and choose properties | start menu tab | customize | advanced | clear list
-If the Word or Excel applications are slow opening the files from the menu, clear the recent document list within the application. To do so in Word; open the application | on the menu bar choose  tools | options | general | un-check "recently used file list | choose OK to apply | then you can go back in and re-enable. Excel is similar.
0
 

Author Closing Comment

by:markkindred
ID: 36542096
The above worked a treat
0
 
LVL 77

Expert Comment

by:Rob Williams
ID: 36542252
Good to hear markkindred. Out of curiosity which fix worked in your case.
Thanks,
--Rob
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The articles for turning off the Client firewall policy on the internet are for SBS 2008 and don't really help for SBS 2011. They actually moved the Client firewall policy. In 2011, the client firewall policy has moved to the SBS computers conta…
If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question