Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel Files not closing properly over a network.

Posted on 2011-03-17
6
Medium Priority
?
585 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
  • 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
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
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 2000 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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

927 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