Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Protecting Formulas
Is it possible to protect a formula and still be able to edit the contents in
the cell without changeing the formula.-- Brose |
#2
|
|||
|
|||
No But: you can have your calculations in one set of cells. In another set
of cells reference the original set. (=A1 etc) and have the second set be your Display set. You can then write over the second set as needed, and "refresh defaults" by re referencing the original set. Ha "brose" wrote: Is it possible to protect a formula and still be able to edit the contents in the cell without changeing the formula.-- Brose |
#3
|
|||
|
|||
Thank you, i still fall into the same problem though because if the user
changes a cell it will overide the =A1 formula. or am I missing something? I know theres a way to make this work so thanks for any and all help -- Brose "bj" wrote: No But: you can have your calculations in one set of cells. In another set of cells reference the original set. (=A1 etc) and have the second set be your Display set. You can then write over the second set as needed, and "refresh defaults" by re referencing the original set. Ha "brose" wrote: Is it possible to protect a formula and still be able to edit the contents in the cell without changeing the formula.-- Brose |
#4
|
|||
|
|||
I guess I am not sure what you want to do.
If you want the display to change but have the cell not change you could do something like in column b =if(C1<"",C1, Calculation) This would let someone effectively write over the display in Column B by entering something in column C If I am reading what you are saying correctly, you want to be able to Enter something directly in a cell but have the cell still have the original equation. I really do not think this is possible. But hopefully there is a wizard out there would can prove me wrong. "brose" wrote: Thank you, i still fall into the same problem though because if the user changes a cell it will overide the =A1 formula. or am I missing something? I know theres a way to make this work so thanks for any and all help -- Brose "bj" wrote: No But: you can have your calculations in one set of cells. In another set of cells reference the original set. (=A1 etc) and have the second set be your Display set. You can then write over the second set as needed, and "refresh defaults" by re referencing the original set. Ha "brose" wrote: Is it possible to protect a formula and still be able to edit the contents in the cell without changeing the formula.-- Brose |
#5
|
|||
|
|||
brose
Have I got this right? You have a formula in a cell and you want to edit that cell without making any changes. You know there's a way for this to work. Post back when you get it done so's the rest of us can learn, please. Perhaps show us what the formula looks like and what you want to edit. Gord Dibben Excel MVP On Thu, 28 Apr 2005 13:12:03 -0700, "brose" wrote: Thank you, i still fall into the same problem though because if the user changes a cell it will overide the =A1 formula. or am I missing something? I know theres a way to make this work so thanks for any and all help -- Brose "bj" wrote: No But: you can have your calculations in one set of cells. In another set of cells reference the original set. (=A1 etc) and have the second set be your Display set. You can then write over the second set as needed, and "refresh defaults" by re referencing the original set. Ha "brose" wrote: Is it possible to protect a formula and still be able to edit the contents in the cell without changeing the formula.-- Brose |
#6
|
|||
|
|||
thanks for the help, i will keep trying. starting to think that 2 colums is
the way i need to go. -- Brose "bj" wrote: I guess I am not sure what you want to do. If you want the display to change but have the cell not change you could do something like in column b =if(C1<"",C1, Calculation) This would let someone effectively write over the display in Column B by entering something in column C If I am reading what you are saying correctly, you want to be able to Enter something directly in a cell but have the cell still have the original equation. I really do not think this is possible. But hopefully there is a wizard out there would can prove me wrong. "brose" wrote: Thank you, i still fall into the same problem though because if the user changes a cell it will overide the =A1 formula. or am I missing something? I know theres a way to make this work so thanks for any and all help -- Brose "bj" wrote: No But: you can have your calculations in one set of cells. In another set of cells reference the original set. (=A1 etc) and have the second set be your Display set. You can then write over the second set as needed, and "refresh defaults" by re referencing the original set. Ha "brose" wrote: Is it possible to protect a formula and still be able to edit the contents in the cell without changeing the formula.-- Brose |
#7
|
|||
|
|||
You have the problem right, unfortunatly Im having a heck of a time finding
a solution. thanks, will keep you posted -- Brose "Gord Dibben" wrote: brose Have I got this right? You have a formula in a cell and you want to edit that cell without making any changes. You know there's a way for this to work. Post back when you get it done so's the rest of us can learn, please. Perhaps show us what the formula looks like and what you want to edit. Gord Dibben Excel MVP On Thu, 28 Apr 2005 13:12:03 -0700, "brose" wrote: Thank you, i still fall into the same problem though because if the user changes a cell it will overide the =A1 formula. or am I missing something? I know theres a way to make this work so thanks for any and all help -- Brose "bj" wrote: No But: you can have your calculations in one set of cells. In another set of cells reference the original set. (=A1 etc) and have the second set be your Display set. You can then write over the second set as needed, and "refresh defaults" by re referencing the original set. Ha "brose" wrote: Is it possible to protect a formula and still be able to edit the contents in the cell without changeing the formula.-- Brose |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting Formulas | New Users to Excel | |||
Protecting formulas | Excel Discussion (Misc queries) | |||
Problem with named formula's | Excel Worksheet Functions | |||
Formulas | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |