#1   Report Post  
jp
 
Posts: n/a
Default cannot edit and save

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



  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
cannot edit and save jp New Users to Excel 1 February 9th 05 04:25 AM
cannot edit and save jp Excel Discussion (Misc queries) 1 February 8th 05 06:12 PM
cannot edit and save jp Excel Discussion (Misc queries) 0 February 8th 05 04:27 AM
How can I save an editable copy of a protected excel workbook? randyice Excel Discussion (Misc queries) 1 December 23rd 04 10:01 PM


All times are GMT +1. The time now is 12:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"