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

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History