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