Can't save files. It says "sharing violation"

  ernieernie 17:41 16 Jun 2007

I had Windows pretty well sussed until I got a new computer with Vista, and now I never seem to run short of problems.
The latest is when I make any alterations to an Excel file (maybe all the others as well, but I haven't tried) I keep getting the following response.
Your changes could not be saved to mydoc.xls because of a sharing violation. Excel has created a temporary file with your changes preserved called 76E82000 (the number changes on every attempt). The said file has no extension and won't let me find Excel to open it.
If I persevere then I sometimes get the following message.
Cannot save C:\ernest\Documents\excel\mydoc.xls. That file is marked Read Only.
I can save it without any bother to pendrive in a USB slot.
It's driving me nuts! Help!

  SANTOS7 17:47 16 Jun 2007

Sharing Violation

An attempt to open a file that is being used by another program. In a normal single-user environment, if an application has already called in a file (document, spreadsheet, etc.), and another program tries to read it, a sharing violation occurs. The solution is to close the file, which releases the "lock" placed on it by the application that opened it.

  ernieernie 21:44 16 Jun 2007

Thanks for trying, but evidently I did not make myself clear. The problem occurs when after opening a file and changing it I try to save it again.

  SANTOS7 21:55 16 Jun 2007

Could be Anti virus software related.

anti-virus software locks the temp file that Excel creates as the first step
in saving a workbook while it scans it. The temp file doesn't get unlocked
quickly enough so Excel throws a sharing violation error. Try disabling all
your dynamic anti-virus scanning and see if the problem goes away.

  woodchip 22:19 16 Jun 2007

Try "Save As" create a new file and delete the old one

  ernieernie 22:28 16 Jun 2007

Thanks again for your rapid response. It is comforting when you know someone is willing to help.
I have been delving into the file sharing setup and deleted all the restrictions I could find - I don't need them anyway as I am a solo user. Anyway, the problem has now disappeared - thank goodness. I still don't really know what I have done or how the restrictions were applied in the first case, but I shan't lose any sleep over it.
Thanks again.

  woodchip 22:31 16 Jun 2007

If you save files to CD then copy them back to your hard drive. it makes them Read Only, and you have to change them back to Archive

  ernieernie 08:05 17 Jun 2007

Thanks for your input.
Before all this started I had partitioned my hard drive and copied my Documents directory/folder to the new partition. I then had a bit of trouble finding which files I was opening or saving so I deleted the original folder in C:\. I wonder if you are right and that the copied files had been made Read Only?
That's the trouble with computers - they do what you tell them instead of what you thought you told them!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

Creative studio Omnibus' brand identity for We Said Enough, a non-profit against sexual misconduct

What to ask Siri on the HomePod

Meilleurs VPN (2018)