| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Formulas changing to it's actual value
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Cell contents from formula to the actual result | Excel Discussion (Misc queries) | |||
| Display results of formulas not the actual formula | Excel Discussion (Misc queries) | |||
| Changing Forecast Data to Actual | Excel Discussion (Misc queries) | |||
| Problem with formulas changing cell reference | Excel Discussion (Misc queries) | |||
Threaded Mode
