Protecting Cells In A Worksheet

[Nicole]

Have followed all the directions to protect certain cells in a worksheet.
After unlocking the cells in the entire sheet I get the following dialogue
box "Too many different cell formulas" and the cells don't get unlocked.

Any suggestions??

 

[Gord Dibben]

You sure it says "formulas" and not "formats"?

Maybe this KB Article will shed some light if "too many formats"

http://support.microsoft.com/default.aspx?scid=kb;en-us;213904


Gord Dibben MS Excel MVP