Solved

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

Posted on 2013-11-19
11
4,567 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 53

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 53

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
 

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
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 53

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 53

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

With Windows evolving further, the built-in protective mechanisms get better and better. Still, Microsoft is not very good at introducing those to the technical community. This article is about a new bitlocker functionality that could revolutionize …
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

706 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now