View Single Post
  #2   Report Post  
Nick Hodge
 
Posts: n/a
Default

Paul

It sound like either the file is shared and has not been un-shared prior to
trying to save in the new version. or... it is locked open by some process.
this happens from time to time. Try re-booting the machine. (That is
switch it off, not just restart. If that doesn't fix it, can you 'Save as'?

Finally try starting Excel in safe mode by going to StartRun and type
excel.exe /safe

Once you have done this you should be able to save the file

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"PaulC" wrote in
message ...

I have just transferred an Excel database consisting of 4 files from
Excel 97 to 2003. One of the files now will not save - when I try I
first get a message 'Can't craeate backup file, save without?' If I say
yes, it says 'Changes can't be saved because of a sharing violation.'

This database works fine in 97, and the other 3 files all save okay in
2003, so I am puzzled. Any ideas?

Paul


--
PaulC
------------------------------------------------------------------------
PaulC's Profile:
http://www.excelforum.com/member.php...fo&userid=7563
View this thread: http://www.excelforum.com/showthread...hreadid=378408