I have a workbook with multiple sheets. In each sheet I have a range of
cells that contain formulas. In previous versions of Excel I was able to
lock the cells that contained formulas and then proctect the sheet (with or
without password). This then allowed any user to input data into cells that
were not locked without the fear of the formulas being overwritten.

In this new version I am using the same spreadsheet as before, but it is not
allowing me to put in the data unless I un-protect the sheet first. If I do
that, it opens up the rest of the sheet and the fomulas could be over typed.

Any ideas of how I can prevent this?