the "options" that you refer to do not address the problem of the
formula cells no longer working when they are protected.
here it is again, when the formula cells are protected , according to
the instructions eg protecting the cells using the format options then
protecting the sheet, the formulas QUIT WORKING !!!!