Question Locked

how to make an excel file read only

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
i'm trying to make a 2003 excel file read only but somehow it doesn't work. when i open the file there is a [read only] specified after the file name but then again i can still edit the worksheet. what should i do to make it read only?

6 replies

by dangolrajesh

Hi, ednagalang@.....
Have you tried this.
Go to the excel> tools> Protection> Protect sheet. There you can see many option like, select locked cell,select unlock cell, format cell, format rows etc. and password. if you put the password it will protect your sheet.
ok try this, i think it will work and this is what you are saying.

by ednagalang

hi dangolrajesh@...
thanks so much. i did what you said and it worked. thanks!

by dangolrajesh

Glad I could help. It is greatly appreciated if you tag all useful responses as 'Helpful' by opening those posts and clicking the 'Mark Helpful' button at the bottom. That way, people with a similar situation in the future will be able to quickly see what ultimately helped. Thanks.

by ednagalang

can i protect the entire workbook instead of protecting it sheet by sheet?

by dangolrajesh

sorry ednagalang i don't know how to protect entire workbook in ms excel.you have to do it sheet by sheet. You can protect entire document in openoffice.org calc only.
best of luck

This discussion is closed to new replies.