Is there a way to lock down, so to speak, an Excel sheet that has formulas housed inside hidden columns? The sheet is used for time entry in a business and people keep deleting and cutting and pasting in rows which messes up the formulas. The sheets are eventually introduced to an importing interface and if the cells do not contain the proper data, the process is toast. How do I lock down the sheet?
Why can't you insert a row into a sheet containing formulas and have the formulas automatically formulate the data?