?
Solved

Excel files hang when opened on a network share

Posted on 2011-04-26
21
Medium Priority
?
2,360 Views
Last Modified: 2012-05-11
Hi.  As of yesterday Excel files on a network share wont open, other documents, such as Word, open fine.  
If the Excel file is copied from the Network location and pasted onto the desktop it opens normally.  Any ideas on why this might happen?
0
Comment
Question by:MYCU
  • 8
  • 6
  • 3
  • +2
20 Comments
 
LVL 25

Expert Comment

by:Brian B
ID: 35474982
First thing that popped into my head was antivirus. Try disabling it temporarily.
Just to narrow the scope, does this happen for all users on all computers? If not, you need to narrow down if the problem is a user or a system.
What exactly happens when you try to open an Excel file from the network? If there is an error message, please post.
0
 
LVL 15

Author Comment

by:MYCU
ID: 35476787
It is happening to both users who have full rights to the share.  They were able to open and work on the Excel files from the location a couple of days ago.  The file eventually opens after about 20 minutes.  No error message.
0
 
LVL 31

Expert Comment

by:Justin Owens
ID: 35477714
Does it happen only when "double clicking" the icon on the share?  If Excel is opened to a blank document, and then File ... Open (or Office Button ... Open, depending on version), does the delay exist there, too?  If the file(s) are on a different network share on a different server, does the delay still happen?

DrUltima
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 25

Expert Comment

by:Brian B
ID: 35477887
Can anyone else access these files with no problems? Also can they create a new file and save it there and open it okay, or does it cause delays.

I'd still try disbaling their anti-virus and retest. Its usually quick and easy to check.
0
 
LVL 15

Author Comment

by:MYCU
ID: 35479633
Disabling the antivirus didnt resolve the issue...  One of the users was able to create an Excel file locally, copy it, paste it on the network share and was able to open it fine.
0
 
LVL 31

Expert Comment

by:Justin Owens
ID: 35484090
MYCU,

Would you mind terrible addressing the questions asked in post http:#a35477714 ?

Respectfully,

DrUltima
0
 
LVL 15

Author Comment

by:MYCU
ID: 35484541
Does it happen only when "double clicking" the icon on the share?  If Excel is opened to a blank document, and then File ... Open (or Office Button ... Open, depending on version), does the delay exist there, too?  If the file(s) are on a different network share on a different server, does the delay still happen?

Not at all,
 It happens (the delay exists) whether the file is double click or access directly from  Excel opened to a blank document, and then File ... Open.

I dont have a different server to test it on, but when the file is copied from the network share to a pc the file opens normally.

I noticed that the time delay it takes to open the file is correlated to its size.  e.g. a 72 kb opens almost immediately whereas a 3640 kb spreadsheet takes about 3 minutes.

0
 
LVL 31

Expert Comment

by:Justin Owens
ID: 35485944
Since you don't have another server to copy this to, is it safe to assume that your server is not only a file server but also a DC, DNS, DHCP, etc.?  If so, what other Roles and Services does it host?  Each of these play into the network responsiveness and will give us clues where to look.

DrUltima
0
 
LVL 31

Expert Comment

by:Justin Owens
ID: 35485955
Additionally, what is the OS of the server and client(s) and the version of Excel?

DrUltima
0
 
LVL 15

Author Comment

by:MYCU
ID: 35486609
Correct, the server is temporarily acting as a File server and a DC.  The OS of the server is Microsoft Windows Server 2003 R2.  The clients OS is Windows XP Pro.  Excel is 2003.
0
 
LVL 31

Expert Comment

by:Justin Owens
ID: 35486685
Since the problem first occurred 4/25/2011 ("as of yesterday"), I am going to ask if anything changed then (adding a new role, for example)?  Also, any reboots since the problem first manifested?
0
 
LVL 15

Author Comment

by:MYCU
ID: 35486804
No changes except work done on Excel spreadsheets. The department clients machines have been rebooted since, so has the server.
0
 
LVL 31

Expert Comment

by:Justin Owens
ID: 35486860
Have you used network monitoring to see how many open, concurrent threads you have on that server?  Windows 2003 is limited to just under 4000 threads (not users or computers) at a time by default.  Because the server is also a DC, etc., it could be that the larger files cause too many threads to be opened.

Have you done any tweaking of this server to try to address this?

DrUltima
0
 
LVL 15

Author Comment

by:MYCU
ID: 35487397
Not yet, but that sounds like a reasonable cause and effect for the issue.  I'll look into it.
0
 
LVL 25

Expert Comment

by:Brian B
ID: 35494351
At least if two users have the same problem from two different systems, we know it isn't specifically PC related.

A lot has happened on this thread, so I might have missed it, but also try disabling antivirus on the workstation (and server, if you have it). It also might pay to have a look at the network load in task manager, and even the switch, just to see if anything is busier than normal.
0
 
LVL 15

Accepted Solution

by:
MYCU earned 0 total points
ID: 35773913
This issue has been resolved through Microsoft support identifying a patch issue.
0
 
LVL 15

Author Closing Comment

by:MYCU
ID: 35807117
Uninstalled the interferring patch.
0
 
LVL 1

Expert Comment

by:domgelato
ID: 36176040
We are experiencing the exact same symptoms, would you mind identifying the patch you uninstalled?
0
 
LVL 1

Expert Comment

by:domgelato
ID: 36176316
Nevermind, found that it was the Microsoft Office File Validation Update. http://support.microsoft.com/kb/2501584. Thanks for pointing in the right direction.
0
 

Expert Comment

by:unitedsystems
ID: 36176317
I had the same problem this afternoon. To fix I had to uninstall the Microsoft Office File Validator Add-in that had automatically installed via update. Everything is back to normal now.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

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