Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 411
  • Last Modified:

Shared spreadsheet slow over network

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
markkindred
Asked:
markkindred
  • 2
1 Solution
 
Rob WilliamsCommented:
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
 
markkindredAuthor Commented:
The above worked a treat
0
 
Rob WilliamsCommented:
Good to hear markkindred. Out of curiosity which fix worked in your case.
Thanks,
--Rob
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now