Yes.

Just do all your setup work before you share the workbook.

Create your formulas, lock/unlock the cells, protect the worksheet

Then share the workbook.



Debi wrote:

is it possible to protect only cells that contian certain formulas within a
shared worksheet yet still have the values on those cells updated when
spreadsheet is opened due to links to other shared worksheets?

--

Dave Peterson