title: Insert row and adopt the formula above (from protected cell)
body: <p>I have an Excel-sheet with a table defined. In this table there are simple calculations for a bill (amount * price = total). The total-cell with this formula is <em>protected</em>.</p>
  
  <p>When I protect the whole worksheet I allow the users to insert rows (so the user can insert new positions to the bill). But when the total-cell is protected, the formula behind this cell is not adopted in the newly inserted cell (without protection, everything works fine).</p>
  
  <p>I know, I can handle this with macro/vba. But this is not an option. Is there another way to achive this? Thanks</p>