Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Sharing Violation when using Excel 2003 on Vista

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sharing violation error in Excel 2007 djbet Excel Discussion (Misc queries) 0 December 12th 07 10:32 AM
i cann't save my excel file on network it says sharing violation agng New Users to Excel 2 September 25th 07 04:04 AM
sharing violation when using excel 2007 John Excel Discussion (Misc queries) 0 April 15th 07 09:04 AM
How do I stop sharing violation errors in Excel 2003 - file NOT sh USAOz Excel Discussion (Misc queries) 1 September 28th 06 05:06 PM
Sharing Violation Error while opening Excel file with Win Runner prabhu Excel Discussion (Misc queries) 0 April 20th 06 06:52 PM


All times are GMT +1. The time now is 04:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"