Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

sharing folders

ResolvedVersion 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

Excel tip:

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.