Solved

Shared spreadsheet slow over network

Posted on 2011-09-14
3
405 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

Technology Partners: 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

Suggested Solutions

This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Small Business Server 2011. NOTE: This guide has been written using the preview version of SBS2011 therefore some of the screens may …
I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

740 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