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.


Submitted via EggHeadCafe - Software Developer Portal of Choice
EggheadCafe.com MSInfo C# Webservice
http://www.eggheadcafe.com/tutorials...-msinfo-c.aspx

I suspect that you have an event macro operating "undercover".

Because the macro may be in the worksheet or workbook area instead of a
standard module, people tend to forget they are there.
--
Gary''s Student - gsnu200909


"Luis Cortes" wrote:

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.


Submitted via EggHeadCafe - Software Developer Portal of Choice
EggheadCafe.com MSInfo C# Webservice
http://www.eggheadcafe.com/tutorials...-msinfo-c.aspx
.

Right-click the tab of the problematic sheet. Click View Code. Do you see
and code in the window that opens? Does it belong there???

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Gary''s Student" wrote:

I suspect that you have an event macro operating "undercover".

Because the macro may be in the worksheet or workbook area instead of a
standard module, people tend to forget they are there.
--
Gary''s Student - gsnu200909


"Luis Cortes" wrote:

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.


Submitted via EggHeadCafe - Software Developer Portal of Choice
EggheadCafe.com MSInfo C# Webservice
http://www.eggheadcafe.com/tutorials...-msinfo-c.aspx
.

No theres no code in there, I can upload the file if you'd like to take a look

http://rapidshare.com/files/315370332/test3.xls

You can see when you change a bit of the numbers in sheet 4 (Calculations)



ryguy7272 wrote:

Right-click the tab of the problematic sheet. Click View Code.
02-Dec-09

Right-click the tab of the problematic sheet. Click View Code. Do you see
and code in the window that opens? Does it belong there???

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Gary''s Student" wrote:

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Silverlight 2 RC0 Doing Data Part VIII : Using the Threadpool
http://www.eggheadcafe.com/tutorials...0-doing-d.aspx

I can upload the file and you can have a look, if you'd like to see if you can fix it.

http://rapidshare.com/files/315370332/test3.xls

Just check the Calculation Sheet and you can chekc it.



Gary''s Student wrote:

I suspect that you have an event macro operating "undercover".
02-Dec-09

I suspect that you have an event macro operating "undercover".

Because the macro may be in the worksheet or workbook area instead of a
standard module, people tend to forget they are there.
--
Gary''s Student - gsnu200909


"Luis Cortes" wrote:

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Free Icons / Graphics For Business Applications
http://www.eggheadcafe.com/tutorials...phics-for.aspx