Solved

Excel Files not closing properly over a network.

Posted on 2011-03-17
6
538 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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Excel formula 5 70
OCT or Config.xml 2 42
TSQL DateADD update Question 4 30
Excel sheet question 12 28
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

867 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now