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 |
#2
|
|||
|
|||
Maybe there are macros that are doing this conversion.
I'd open that workbook with macros disabled (change your security to medium) and answer No to the enable macro prompt. If none of your formulas are overwritten, then it's time to find out why those macros exist and if they've overstayed their welcome. (and how they should change or if they should be deleted). Ned wrote: 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 -- Dave Peterson |
#3
|
|||
|
|||
Dave,
Thanks for the advice. I tried disabling the macros and also deleting them from the file, but I am still having the same problems. I am not sure what else could be causing this strange problem. best, Ned "Dave Peterson" wrote: Maybe there are macros that are doing this conversion. I'd open that workbook with macros disabled (change your security to medium) and answer No to the enable macro prompt. If none of your formulas are overwritten, then it's time to find out why those macros exist and if they've overstayed their welcome. (and how they should change or if they should be deleted). Ned wrote: 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 -- Dave Peterson |
#4
|
|||
|
|||
One way to make sure all macros are disabled is to open excel in Safe mode:
Windows start button|Run Excel /safe Then file|open your workbook and see what happens. I don't have any better guesses right now. What do your formulas look like--just in case there's something special about them? Ned wrote: Dave, Thanks for the advice. I tried disabling the macros and also deleting them from the file, but I am still having the same problems. I am not sure what else could be causing this strange problem. best, Ned "Dave Peterson" wrote: Maybe there are macros that are doing this conversion. I'd open that workbook with macros disabled (change your security to medium) and answer No to the enable macro prompt. If none of your formulas are overwritten, then it's time to find out why those macros exist and if they've overstayed their welcome. (and how they should change or if they should be deleted). Ned wrote: 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 -- Dave Peterson -- Dave Peterson |
Reply |
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 |