Maybe this FAQ at Debra Dalgleish's site would help:
http://www.contextures.com/xlfaqApp.html#ReadOnly
And file is locked is refering to the lock put it on it by windows--not the
locked property of a cell.
When you open a file, windows will keep track of it and make sure no one
else--including you! can open it while you have it.
Sometimes, windows gets confused. Debra shows some things to try to fix it.
jp wrote:
hi,
i am using excel 2000. i cannot edit and save a existing file.
the file is not protected,not read only and not shared.
when i open the file, a Microsoft excel window appear saying "File is
locked. In order to save changes to the file, you can either close the file
before making any changes and then re-open it, use Save As (File menu) to
save the file using another filename, or turn off Shared Workbooks and then
save the file."
i try to clear the checkbox on the format cellsprotectionLocked
but still when i click save a window appear saying "Document not saved"
please help
--
Dave Peterson