problems saving excel file

[Linda]

Networked computers with Win 2000 server. Workstations are a mix of Win 2000
Pro and XP Pro. They have successfully shared an Excel file for several
years. - all workstations have full retail version of Office Pro 2000 or
Office Pro 2002. We just added a new XP Pro computer and are having a
problem.
One of the users has the Excel file open (it is stored on a shared network
drive on the server - remember - this has worked for over 2 years - this
problem has only been since the addition of the new Dell computer) and will
make a change - when they try to close and save the file they get the
following -

Your changes could not be saved to 'Filename.xls' because
of a sharing violation. Excel has created a temporary
file with your changes preserved, called 'random file
name'. You can save the temporary file as a new name or
lose your changes and all future changes.

They have to open the tmp file created - rename it - and save it as an xls
file.
What is going on???? Is the new compter causing this? The new user has the
standard permissions to the shared folder. It does not happen everytime but
perhaps one out of three times the file is opened and also has happened to
several of the users on the Win 2000 computers as well as on the new XP
computer.
Thanks for any help.
Linda

 

[Rob Bovey]

Hi Linda,

I don't know if this is what's causing the problem for you, but I've
seen several cases where this was caused by anti-virus software. The
anti-virus software locks the temp file that Excel creates as the first step
in saving a workbook while it scans it. The temp file doesn't get unlocked
quickly enough so Excel throws a sharing violation error. Try disabling all
your dynamic anti-virus scanning and see if the problem goes away.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

 

[Linda]

Thanks for the suggestion Rob -
however - they use Norton small business antivirus that is managed from the
server - so all use the same verion and updates - did not have the problem
until a few weeks ago and they have had the antivirus for over a year -
guess it could be in one of the updates on second thought so will try
turning it off when I am on site tomorrow -

I wonder if it could have anything to do with the 2 verisons of Office -
they have Office 2000 on all computers but the new one that has Office 2002
???
Has anyone experienced problems with mixing these?? I know there are
problems with the older versions of Access and the newer releases but have
not heard the same about Excel.

Linda