PC Review


Reply
Thread Tools Rate Thread

Sharing violation

 
 
Nathan
Guest
Posts: n/a
 
      23rd Dec 2009
I am getting the following error message every time I try to save an existing
file in MS Excel 07:

"Your changes could not be saved to 'filename.xlsx' because of a sharing
violation. Try saving to a different file."

Additional info:
- This occurs for every existing file, but I don't have any issues saving
new files
- If I create a new file and then try to update and save it, I get the same
issue
- I understand the normal Excel save process sees a temp file being created
in the location of the original file, the original file then being deleted
and the temp file being renamed to the original filename. It seems as though
Excel is creating the temp file in the original location and then falling
over on the subsequent steps (as I get a new temp file each time I try to
save)
- No issues with my other office products
- I have file and print sharing turned off (I've tried turning it on)
- I don't believe any settings in Excel are curently set to non-standard
settings, but I'd appreciate any tips

Thanks.
 
Reply With Quote
 
 
 
 
trnicho77
Guest
Posts: n/a
 
      23rd Dec 2009
I had this same issue and after a lot of searching I found a way to make this
error go away.

I'm using Win7, Trend Micro, and Office 07 Pro.

I found an article that suggested turning off and disabling windows search
or disabling my anti-virus. I didn't want to disable my anti-virus and I
don't really use my windows search bar so I chose to try turning off and
disabling windows search... and it worked. Well I should say it has worked
so far. I made this change yesterday afternoon and haven't had any issues
since. I was experiencing this issue 4 to 5 times a day since upgrading my
system to Win7. Give it a try. If it doesn't solve your issue, then you can
always restart and enable windows search.


"Nathan" wrote:

> I am getting the following error message every time I try to save an existing
> file in MS Excel 07:
>
> "Your changes could not be saved to 'filename.xlsx' because of a sharing
> violation. Try saving to a different file."
>
> Additional info:
> - This occurs for every existing file, but I don't have any issues saving
> new files
> - If I create a new file and then try to update and save it, I get the same
> issue
> - I understand the normal Excel save process sees a temp file being created
> in the location of the original file, the original file then being deleted
> and the temp file being renamed to the original filename. It seems as though
> Excel is creating the temp file in the original location and then falling
> over on the subsequent steps (as I get a new temp file each time I try to
> save)
> - No issues with my other office products
> - I have file and print sharing turned off (I've tried turning it on)
> - I don't believe any settings in Excel are curently set to non-standard
> settings, but I'd appreciate any tips
>
> Thanks.

 
Reply With Quote
 
 
 
 
bdc
Guest
Posts: n/a
 
      20th Jan 2010
That great but what about those of use who wnat to use Windows search?
Microsoft do you ahve an answer

"trnicho77" wrote:

> I had this same issue and after a lot of searching I found a way to make this
> error go away.
>
> I'm using Win7, Trend Micro, and Office 07 Pro.
>
> I found an article that suggested turning off and disabling windows search
> or disabling my anti-virus. I didn't want to disable my anti-virus and I
> don't really use my windows search bar so I chose to try turning off and
> disabling windows search... and it worked. Well I should say it has worked
> so far. I made this change yesterday afternoon and haven't had any issues
> since. I was experiencing this issue 4 to 5 times a day since upgrading my
> system to Win7. Give it a try. If it doesn't solve your issue, then you can
> always restart and enable windows search.
>
>
> "Nathan" wrote:
>
> > I am getting the following error message every time I try to save an existing
> > file in MS Excel 07:
> >
> > "Your changes could not be saved to 'filename.xlsx' because of a sharing
> > violation. Try saving to a different file."
> >
> > Additional info:
> > - This occurs for every existing file, but I don't have any issues saving
> > new files
> > - If I create a new file and then try to update and save it, I get the same
> > issue
> > - I understand the normal Excel save process sees a temp file being created
> > in the location of the original file, the original file then being deleted
> > and the temp file being renamed to the original filename. It seems as though
> > Excel is creating the temp file in the original location and then falling
> > over on the subsequent steps (as I get a new temp file each time I try to
> > save)
> > - No issues with my other office products
> > - I have file and print sharing turned off (I've tried turning it on)
> > - I don't believe any settings in Excel are curently set to non-standard
> > settings, but I'd appreciate any tips
> >
> > Thanks.

 
Reply With Quote
 
Ron
Guest
Posts: n/a
 
      27th Jan 2010
We also use Trend Micro a/v here in my office. It seems everyone has been
having this Sharing Violation error lately, I've assumed it was Trend Micro
scanning the file when it gets accessed and not completing fast enough. It
always saves on the second try. I'll try disabling search too..

"trnicho77" wrote:

> I had this same issue and after a lot of searching I found a way to make this
> error go away.
>
> I'm using Win7, Trend Micro, and Office 07 Pro.
>
> I found an article that suggested turning off and disabling windows search
> or disabling my anti-virus. I didn't want to disable my anti-virus and I
> don't really use my windows search bar so I chose to try turning off and
> disabling windows search... and it worked. Well I should say it has worked
> so far. I made this change yesterday afternoon and haven't had any issues
> since. I was experiencing this issue 4 to 5 times a day since upgrading my
> system to Win7. Give it a try. If it doesn't solve your issue, then you can
> always restart and enable windows search.
>
>
> "Nathan" wrote:
>
> > I am getting the following error message every time I try to save an existing
> > file in MS Excel 07:
> >
> > "Your changes could not be saved to 'filename.xlsx' because of a sharing
> > violation. Try saving to a different file."
> >
> > Additional info:
> > - This occurs for every existing file, but I don't have any issues saving
> > new files
> > - If I create a new file and then try to update and save it, I get the same
> > issue
> > - I understand the normal Excel save process sees a temp file being created
> > in the location of the original file, the original file then being deleted
> > and the temp file being renamed to the original filename. It seems as though
> > Excel is creating the temp file in the original location and then falling
> > over on the subsequent steps (as I get a new temp file each time I try to
> > save)
> > - No issues with my other office products
> > - I have file and print sharing turned off (I've tried turning it on)
> > - I don't believe any settings in Excel are curently set to non-standard
> > settings, but I'd appreciate any tips
> >
> > Thanks.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sharing violation and MP3s - how to stop the sharing violation w/o rebooting? StargateFan Microsoft Windows 2000 New Users 3 12th May 2006 11:49 AM
Key violation and lock violation stop delete query!! =?Utf-8?B?RG93bmluZ0RldmVsb3BtZW50cw==?= Microsoft Access Queries 2 4th Aug 2005 11:07 AM
Windows XP - NTuser.dat Sharing Violation Marvin Gloven Windows XP Help 1 26th Aug 2004 04:28 AM
peer to peer network sharing violation =?Utf-8?B?RXpyYSBPdW5jZQ==?= Windows XP Security 0 23rd Aug 2004 02:39 PM
Sharing violation Jim Slager Windows XP Networking 3 30th Jan 2004 04:08 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:19 PM.