98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Sharing folders
Sharing folders
Resolved · Low Priority · Version 2003
Sacha has attended:
Excel Introduction course
Sharing folders
How do you allow others to read but not change data?
RE: sharing folders
Hi Sacha,
Thank you for your question.
Do you mean how do you protect a spreadsheet?
If so, you need to go to Tools and then Protection, Protect Sheet. Choose a password type it in and click OK and then re-enter the password to confirm. When anyone opens the file, only the people who know the password can edit anything.
If you need to edit the spreadsheet, you need to go to Tools, Protection and Unprotect Sheet. Type your password in and you can edit the sheet.
Don't forget the password though.
I hope this answers your question.
Regards
Simon
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Quickly insert a functionIn Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog. |