formula disappear!!!!

[Caroline]

I enter a formula (any formula) in cell A1. Let say I
enter the simplest formula =B2.
If I now change the value in B2, the cell A1 does not
contain anymore the formula, but just the value of B2.
I do not understand what is happening. The only thing I
can think of is that that cell A1 used to be populated by
a macro, but that macro does not exist anymore.
Before you ask... the Propection/Hidden is not switched
on.
Can you help?

 

[Kalle]

what is exactly what you told Excel to do:
the formula says: show me in cell A1 the value of B2.

the formula still sits in A1 and does what you want.

 

[Guest]

No actually, the formula has disappeared, ie. does not
sit anymore in A1 (like if I had done a copy, paste
value). I am an advanced Excel user, and this is the
first time I am experiencing that problem.

 

[Kalle]

ok. sorry.

could it be a strange circular reference?
If not, does this appear in only one Workbook? (maybe damaged file)

sounds strange anyway...

 

[David McRitchie]

Right click on the sheet tab to make sure there are no event
macros in view code.

When you open the workbook, turn off macros.

Does this behavior happen for a formula in any cell in any sheet
of this particular workbook, and only this workbook.

Also is there anything grayed out on the format menu.

 

[Steve Hieb]

Caroline,

There must be code (macro) making the change. Go to the Visual Basic
Editor (ALT+F11) and search the whole project for "Worksheet_Change"
or "Worksheet_SelectionChange" or "Worksheet_Calculate". The code
changing it is probably triggered by one of these events, but it could
be elsewhere. It may not be obvious either (i.e. they might have used
a named range to refer to "A1").

HTH,
Steve Hieb