Problem:

very slow to open a shared worksheet in excel 2010 remotely. locally open is not a problem. I don't know why?

• Moved by Lanlan HuangMicrosoft contingent staff Monday, April 20, 2015 2:19 AM

Hi Marseugene,

If this issue is occurred by a *.xlsx file or other files? Did you enable the Share Workbook option for you workbook? And if only you get this issue, or other users also have this problem?

There are articles about excel opens slowly over network, please refer to these links:

https://support.microsoft.com/en-us/kb/2570623

http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2011/09/29/office-file-validation-causes-slow-opening-of-excel-files-from-network.aspx

It seems that Office File Validation (OFV) causes the issue, you can download and install the Office 2010 File Validation update to help you solve the issue.

https://support.microsoft.com/en-us/kb/2553065

If the issue still exists, you can refer to these articles above and try the workarounds to help you solve your problem.

Or if your issue was caused in wireless net network, please read this article:

https://support.microsoft.com/en-us/kb/2807742

The workaround about this kind of issue is to delete the custom views that you do not need. Then, clear the Print settings check box under the Include in personal view heading in the Share Workbook dialog box. Or, use Excel Services and Microsoft SharePoint instead of the Share Workbook option.

And the issue also might be related to Internet Explorer performing a search of network drives and your local area network and any disconnected network drives or LAN search issues will hang the loading of your Excel spreadsheet. Here is how to stop Excel 2010 from browsing your LAN / Network drives when you open an Excel spreadsheet on your local hard drive:

1. Start Internet Explorer
2. Go to "Tools" menu
3. Go to "Internet Options"
4. Go to "Security" tab
5. Go to "Local Intranet"
6. Click on "Sites" button
7. Uncheck "Automatically detect intranet network"

Please try these methods and let me know if they work, I am glad to help and forward to your reply.

Regards,