• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 592
  • Last Modified:

Excel Files not closing properly over a network.

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
BrandanC
Asked:
BrandanC
  • 3
  • 3
1 Solution
 
rorybreenCommented:
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
 
BrandanCAuthor Commented:
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
 
BrandanCAuthor Commented:
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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
rorybreenCommented:
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
 
BrandanCAuthor Commented:
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
 
rorybreenCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now