Sharing violation

[Nathan]

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.

 

[trnicho77]

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.

 

[bdc]

That great but what about those of use who wnat to use Windows search?
Microsoft do you ahve an answer

 

[Ron]

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..