Solved

Excel Files not closing properly over a network.

Posted on 2011-03-17
6
571 Views
Last Modified: 2012-05-11
Hi,

The issue i am experiencing is that when a certain user saves Excel Files to a network share it does not properly close them. They stay open in the "View Open Files" dialog box on the server. It does not happen with every excel file or from every computer or user, just the one user and only some of the time. (It seems to happen more frequently with larger spreadsheets).

Enviroment Information:

The Clients are running Excel 2003 on Windows XP.
The server is running Windows Server 2008 SBS
Every client connects to the server with the same Network credentials (Its not a domain enviroment)

Any help would be appreciated,

Thanks
--Brandan
0
Comment
Question by:BrandanC
[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
  • 3
  • 3
6 Comments
 
LVL 5

Expert Comment

by:rorybreen
ID: 35161088
Is the user reporting any other network related issues ?

Try changing the network cable or switch port that the user is connected it..

Also check if they have Wi-FI enabled (if it's a laptop that is and you have wi-fi)
0
 

Author Comment

by:BrandanC
ID: 35161211
He isn't having issues with Word or any networked programs. Shares usually comeup just fine and have almost no hangups with browsing.

I've tried swapping where it is on the switch but not which cable run it is. (I'll give that a try)

No Wi-fi just 10/100.

0
 

Author Comment

by:BrandanC
ID: 35191552
Alright, I've switched out the cable for a known good run and that did not solve the issue.
I also updated the network card Drivers to no effect..

Any other ideas?
0
Office 365 Training for Admins

Learn how to provision tenants, synchronize on-premise Active Directory, and implement Single Sign-On with these master level course.  Only from Platform Scholar

 
LVL 5

Expert Comment

by:rorybreen
ID: 35191576
Any ideas what is different on this users computer...

Are they running a different version of your AV..

Is office Service Packed to a different level than other users ?

Do the user have the same problem if he saves the file locally ?

Do any other users use the same file as him ?

What type of backup software do you run, would this be locking the file ?
0
 

Author Comment

by:BrandanC
ID: 35191671
They are running the same operating system and are of apparently the same age.

Niether one is running an AV program.

The machine that does not close it properly is running office 2003 SP3. The one without issue is running office 2003 SP0.

He does not have the same problem if he saves it locally. Only if it is saved to the SBS 2003 Server.

The other computer that uses this file never seems to leave it open or locked.

Running a xcopy script to do backup, however i can pretty much rule that out since i can force the problem to happen. just try saving the excel file a few times and it eventually will take longer than normal to close and will still be open on the server under "View Open Files' when completed.
0
 
LVL 5

Accepted Solution

by:
rorybreen earned 500 total points
ID: 35192044
I wonder if it's due to the service pack but I would not recommend installing it on the non service packed computer.

I would recommend you focus on determinning what else differs between the two computers as this will give us further areas to reasearch.

Do you use DHCP to assign IP addresses or are they manual ?

If manual, try another IP address on the computer with the problem..

Does the user have the same problem if they save to a different directory on the server ?

Apologies, just thinking aloud really.

= Try renaming the file

=Check the computer is fully patched from a Windows Update perspective.

Do you have WINS deployed ?

Confirm the Network settings on both computers are identical ?

Try setting the Network duplex and speed to 100 half.. see if that help ?

Are there any errors on the Event viewer on the server itself ?

What scheduled tasks do you have running on the server in relation to storage ?

0

Featured Post

Office 365 Advanced Training for Admins

Special Offer:  Buy 1 course, get 2nd free!  Buy the 'Managing Office 365 Identities & Requirements' course w/ Accelerated TestPrep, and automatically receive the 'Enabling Office 365 Services' course FREE!

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
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 …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

739 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