Problems with Formulas changing to it's Value

**Luisco** · 12-02-2009, 05:43 AM

Hello,

I have a problem in Excel, I've basically done alot of forms and text but after a while I realised, when I changed the value, the formula which uses that cell in it's formula replaces the cell's formula with the actual value.

For Example:

A1= B2+B3
B2= 5
B3= 6

If I chaneg B2 and B3 to 7 and 7

A1 Changes to 14, and removes B2+B3 from it's formula.

At first I thoguht it was a macro that I made, and when I open the workbook again and disable macros, it all works fine, but when I enable macros and delete the macro. It still happens?

Any idea as to why this is happening? I haven't changed any settings or anything. Btw I'm using Excel 2003

**teylyn** · 12-02-2009, 06:39 AM

This is hard to solve without seeing the workbook and the macro that may cause the changes. Can you upload a sample workbook that shows that behaviour? To upload a file click "go advanced" below and then the paper clip icon.

cheers

**Luisco** · 12-02-2009, 09:36 AM

I have attached the file (a older version) of it where its acting up. Just open it and go to the Calculations Sheet, try changing some of the values and you'll see what I mean.