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
BrandanCAsked:
Who is Participating?
 
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
 
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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

All Courses

From novice to tech pro — start learning today.