D
David Bryant
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.
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.