I have a spreadsheet with multiple formulas, all working fine, happy days !
Then I return to the spreadsheet, never having closed it, and hey presto the formulas are now hard numbers, (the product of the formula).
I have recreated this error using a simple formula with two columns of 20 numbers, and setting a simple running total
a1-b1 = c1
c1+a2-b2=c2 etc
but the result having been given, when examine the formulas after half an hour, all formulas are now hard numbers,
WHY WHY WHY !!!
please help
I would guess either a Macro or a (recent) Add-In are at the root of the problem.
One possible cause is a macro. A macro can be written that will fire on the change of a cell or cells, or perhaps when the sheet calculates.
One instruction, such as this, would replace the formula with the results:
Cells(1,1) = Cells(1,1).ValueHowever, something like this would happen immediately.
Another possibility would be if the formula was highlighted and F9 was pressed.
Sure sounds strange.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.