Protecting a Calculation Cell

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

I'm desperately trying to protect a formula call so that
users cannot blow out the formula. I have locked and
secured the worksheet, but now it's not calculating when
new figures are entered. Please can anyone offer me some
direction?

Much thanks
Mary
 
Mary,

Protection doesn't affect Excel's recalc. As long as the calculation
depends on a cell that is being changed, the formula should update properly.
Make sure that you didn't change the recalc mode to manual.

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

protecting certain cells in Ecxel 2007 2
Why is AutoSum iinoperable w/protection when column is unlocked? 2
Deleting Rows Containing Protected Cells 2
Multi worksheet protection & editing ability 6
Protecting Excel Formulas 2
calculate shipping costs in excel 2007 2
Excel 2003 - Protecting Cells but allowing external data updates 3
How can i protect a formula and still allow copy and move data? 1

Back
Top