Why is opening my Excel files on a network share very slow?

Jaypee C August 28, 2013
Pinterest Stumbleupon Whatsapp

Computers on my network are clean for viruses and malware but still opening these files on the network is relatively slow.

What is confusing is that computers not accessing a network share are working just fine.

  1. Jan F
    August 28, 2013 at 4:36 pm

    That's hard to say without knowing the full infrastructure.

    What OS are the server & clients running? What protocol are the clients using to access the share? Details about the server storage e.g. RAID Level, internal or external, connector (USB, FC, iSCSI).

    You have already ruled out the clients, that is a good start. Is it a purely Excel or Office related issue or is it general with files residing on the network share? Test some other files like PDFs, images if they are effected.

    Another good start is analyzing bandwidth and throughput between client(s) and server using iperf. This will tell you if it is a network infrastructure issue
    http://iperf.fr/

    It is also a good idea to test the storage throughput directly on the server.
    For Linux you can do this in the terminal using hdparm
    "hdparm -tT /dev/sda" (replace /dev/sda with the appropriate storage device of course)
    On Windows you could use HD Tune or ATTO Disk Benchmark (registration required, but tool is free)
    http://www.hdtune.com/
    http://www.attotech.com/disk-benchmark/

    I this should help you narrow down where the slow-downs happen.

    • Bruce E
      August 28, 2013 at 10:07 pm

      OP should probably also check the server and network load. This can be done using Performance Monitor on the server by looking at CPU, disk, and network counters on Windows.

      It would also be good to know if this is an intermittent issue (server/network load issues), if it affects only a few files (failing disk issues?), and exactly what is meant by "relatively slow."

  2. Hovsep A
    August 28, 2013 at 1:35 pm

    A computer that is running Windows 7 or Windows Server 2008 R2 takes four minutes to open a Microsoft Office 2003 document from a network share
    http://support.microsoft.com/kb/982860

    "0x000000D5" Stop error when you run an application or transfer some data from a shared DVD disc on a server in Windows 7 or Windows Server 2008 R2
    http://support.microsoft.com/kb/981711

    1) disable SMB for Windows Vista, Windows 7
    http://support.microsoft.com/kb/2696547
    sc.exe config lanmanworkstation depend= bowser/mrxsmb10/nsi
    sc.exe config mrxsmb20 start= disabled
    2) disable SMB server
    Registry subkey:
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParameters
    Registry entry: SMB2
    REG_DWORD: 0 = Disabled
    3)Reboot Server