View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default Sharing Violation when using Excel 2003 on Vista

You might want to also post your question in
microsoft.public.windows.vista.general. This sounds like it might be a Vista
issue that might be related to things other than Excel as well.

Tyro

"David Bryant" <David wrote in message
...
We have a problem with Excel 2003 running on Vista.

We have several spreadsheets which are used by multiple users, and which
are
configured as shared workbooks. On our XP machines we have never had a
problem with them, but under Vista, we seem to get the following error
when
trying to save them even if nobody else has the sheet open

'Your changes could not be saved to '(name).xls' because of a sharing
violation. Try saving to a different file.

This then results in a file with a name containing a mixture of letters
and
numbers (and no extension) appearing in the same directory as the original
spreadsheet. These files cannot be deleted as an error saying they are in
use
appears - even when they aren't in use. They can only be deleted once the
server has been rebooted. If the original file is opened on an XP machine
after somebody has tried to save it on a Vista machine the Vista user is
still shown as editing the sheet - even if their computer has been
restarted.

This problem seems to affect all of our Vista machines, but none of the XP
ones -and all of them are running Excel 2003. Anyone know what I can do
about
it? I've tried all the usual things like checking file access permissions.