Workbook - Read Only

[SaraHall :)]

How do I make a spreadsheet so that everyone my view it but only I can make
changes?

 

[Dave Peterson]

You could lock each cell on each sheet, then protect each sheet with a password.

But worksheet protection is easily broken.

You could store the workbook on a network share that the users have readonly
access to, but then they could save it to a new location, unprotect the
worksheets and do what ever they want. But they won't be able to update that
"real" workbook. I'd talk to the IT staff and see if they could set it up for
you.

There's really no good way to stop anyone who wants to make changes to some
version of the workbook.

 

[SaraHall :)]

Thank You

You could lock each cell on each sheet, then protect each sheet with a password.

But worksheet protection is easily broken.

You could store the workbook on a network share that the users have readonly
access to, but then they could save it to a new location, unprotect the
worksheets and do what ever they want. But they won't be able to update that
"real" workbook. I'd talk to the IT staff and see if they could set it up for
you.

There's really no good way to stop anyone who wants to make changes to some
version of the workbook.