Solved

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

Posted on 2013-11-19
11
4,708 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Outlook Free & Paid Tools
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
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…
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 …

896 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

13 Experts available now in Live!

Get 1:1 Help Now