Problem with Formulas changing to it's actual value

[Luis Cortes]

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/tutorial...370-1c495e1b3619/eggheadcafecom-msinfo-c.aspx

 

[Gary''s Student]

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.

 

[ryguy7272]

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---

 

[Luis Cortes]

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 se
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''

:

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/tutorial...4-e7c3d0508052/silverlight-2-rc0-doing-d.aspx

 

[Luis Cortes]

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
standard module, people tend to forget they are there
-
Gary''s Student - gsnu20090

:

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Free Icons / Graphics For Business Applications
http://www.eggheadcafe.com/tutorial...1b-a1be20ad935f/free-icons--graphics-for.aspx