how do I protect a formula in an excel speadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a excel speadsheet that figures hours between maintanence
when maintanence is completed I need to reset the time in hours but when I do
that it replaces the formula in the cell and will no longer function
automaticlly unless I replace the formula again. How can I set it to be able
to zero the time and not loose the formula in that cell?
 
Greg
To keep that formula in the cell you will have to change the dependent
cells that the formula uses. If you simple replace the formula, you will
have the same number you had before. HTH Otto
 

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

How do I print my spreadsheet to show the formulas of a cell? 3
sumif formula to calculate value of cell if certain criteria are m 5
change an excel speadsheet in 2002, save it, view it in 2000, 200. 5
EOMONTH formula randomly converts to NA 5
How do I limit formula results to positive only? 4
Creating a formula by using data in another file 2
countif with multiple functions 5
Excel Protection 2

Back
Top