Dave when you say do my setup before I share the workbook, I am not sure I
understand or perhaps I did not give the correct information at first. I am
an auditor and therefore the workbooks I am need to protect my formulas in
have already been written by someone else is it still possible to protect
those cells of after the design and data input on the workbook. Also when you
state lock and unlock the cells then protect the sheet, the only cells I want
protected are those that I have entered formulas into those are also the
cells that are updated when opening the workbook some of the remaining cells
are accessed by other for either viewing or adding data in.

"Dave Peterson" wrote:

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