Solved

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

Posted on 2013-11-19
11
5,216 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 4
11 Comments
 
LVL 55

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 55

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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 55

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 55

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

717 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