Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel formula randomly changes to hard-code number
I am having an issue with an Excel model that was orginally written by some
of my predecessors at work. I do not know the complete history of the file, but it would be extremely time consuming to recreate. When I change certain values in the model some formulas randomly disappear and are replaced by hard-code numbers. The numbers are the right result of the formula, but the formulas are overwritten with the result. If I retype the formulas they will sometimes be fine and other will go back to a hrad-code number. thanks for any assistence. Ned |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula divide list of #s by N to get a number above 40 | Excel Discussion (Misc queries) | |||
Polynimial trandline formula | Charts and Charting in Excel | |||
Looking for function or formula to calculate number that is revers | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions |