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.

MIKE

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.

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History