Forum Discussion

v-josephc's avatar
v-josephc
Former Employee
Jun 21, 2022
Solved

Protect columns in a table while allowing new rows

tl;dr - I’m trying to protect certain columns with formulas in them, so nobody will be able to edit them. I also need to allow these formulas to copy down whenever someone adds a new row to the table...
excel
Excel for web
Formulas and Functions
  • Martin_Weiss's avatar
    Martin_Weiss
    Jun 22, 2022

    Hi v-josephc 

     

    you describe a very common issue and unfortunately Excel does still not allow to activate sheet protection while still being able to use the formatted tables functionality (e.g. copy formulas).

     

    The only advise that I have is to add already enough blank rows in your table, so the users would not have to do that by themself. And then activate the sheet protection to lock the formula cells.

    It's not ideal and maybe not practical in your situation, but I have no better advise.

Martin_Weiss's avatar
Martin_Weiss
Bronze Contributor
Jun 22, 2022

Hi v-josephc 

 

you describe a very common issue and unfortunately Excel does still not allow to activate sheet protection while still being able to use the formatted tables functionality (e.g. copy formulas).

 

The only advise that I have is to add already enough blank rows in your table, so the users would not have to do that by themself. And then activate the sheet protection to lock the formula cells.

It's not ideal and maybe not practical in your situation, but I have no better advise.

  • v-josephc's avatar
    v-josephc
    Former Employee
    Jun 24, 2022
    Thanks for the response Martin!

Resources