excel error Excel Formulas are converting to Hard Numbers

March 20, 2013 at 03:01:00
Specs: Windows XP
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


See More: excel error Excel Formulas are converting to Hard Numbers

Report •


#1
March 20, 2013 at 03:56:29
I would guess either a Macro or a (recent) Add-In are at the root of the problem.

MIKE

http://www.skeptic.com/


Report •

#2
March 20, 2013 at 03:57:15
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).Value

However, 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.


Report •
Related Solutions


Ask Question