Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Shared spreadsheet slow over network

Posted on 2011-09-14
3
Medium Priority
?
409 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 2000 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

Introduction At 19:33 (UST) on Tuesday 21st September the long awaited email arrived with the subject title of “ANNOUNCING THE AVAILABILITY OF WINDOWS SBS 7 PREVIEW”.  It was time to drop whatever I was doing and dedicate as much bandwidth as possi…
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…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

715 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