Solved

Opening office files from network share is slow (Win 8 and Office 2013)

Posted on 2013-11-19
11
4,903 Views
Last Modified: 2014-02-26
Windows 8
Office 2013

When opening up a file on a network share it takes several seconds.  There is a message in the status pane at the bottom that says "downloading" file while it lags and eventually opens.

See this link for a screenshot.

This does not happen on local files and it appears that file size does not matter either. So far I can verify and repeat this behavior on Word and Excel files.

Thanks in advance for solution suggestions!
0
Comment
Question by:wintensivetech
  • 7
  • 4
11 Comments
 
LVL 54

Expert Comment

by:McKnife
ID: 39661721
Hi.

Could it be file validation? Here's how to turn it off for a test: http://technet.microsoft.com/en-us/library/ee857084.aspx#turnoff
File validation is known for being slow over the network.
0
 

Author Comment

by:wintensivetech
ID: 39661753
I will try that now. However, that article does not actually explain how to find that setting anywhere. Do you know where to find it in Excel 2013?
0
 
LVL 54

Expert Comment

by:McKnife
ID: 39661758
Let me quote my link: "If you want to prevent files from being validated by the Office File Validation feature, we recommend that you use the Trusted Locations feature. Files that are opened from trusted locations skip Office File Validation checks. You can also use the Trusted Documents feature to prevent a file from being validated by Office File Validation. Files that are considered to be trusted documents do not undergo Office File Validation checks. "

That should do for a test.
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

Author Comment

by:wintensivetech
ID: 39661780
Thanks. So I added the network share to the trusted locations, and it still does the same thing.  Is there anything you need to do besides close and restart Excel to apply that setting?
0
 

Author Comment

by:wintensivetech
ID: 39661786
Also, periodically this is the window we get from office 2013 about how it has to first download the file from the network before it can open it:

Click here for screenshot
0
 
LVL 54

Expert Comment

by:McKnife
ID: 39661809
>  Is there anything you need to do besides close and restart Excel to apply that setting? - no, that should be it. So it seems to be something else. My experience with 2013 is very limited and I have no test installation to confirm at the moment, sorry.
0
 

Author Comment

by:wintensivetech
ID: 39663961
Not sure if it helps but I'm noticing the following:

The Group Policy Client service fails every day on this machine.

We are moving away from having a full Domain server here so this system is not on the domain. But the server share it is connecting to is the current server that is the domain controller.

Any other suggestions form anyone are much appreciated.
0
 

Author Comment

by:wintensivetech
ID: 39664429
It appears now that the main difference I see is this:

The original file is saved as XLS.  If I save it as XLSX, the file opens quickly over the network. If I save the file as CSV it opens quickly as well.  So it appears to only be the old office 97-2003 XLS format that is a problem. Likely the same thing with WORD so I'll test that now.

Any solutions?
0
 
LVL 54

Expert Comment

by:McKnife
ID: 39877862
...3 months later...
How is it going?
0
 

Accepted Solution

by:
wintensivetech earned 0 total points
ID: 39878766
never figured it out. Had to rename all files and save as xlsx
0
 

Author Closing Comment

by:wintensivetech
ID: 39888251
no one else offered a viable solution...
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

If you use NetMotion Mobility on your PC and plan to upgrade to Windows 10, it may not work unless you take these steps.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

840 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