Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
reference cell
I have typed a value (1500) into cell A5. I have typed a simple formula in
another cell (B5). The formula was =A5*2. When I then changed the value in A5 to 1000 the value in B5 didn't change. Why is this? I have just started using Vista and used to do a lot of formulas before and never had this problem. How do I solve it? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
reference cell
Given that it calculated correctly when you first entered the formula this is
a longshot but try:- Tools|Options|calculation and make sure it's set to automatic. Mike "Susie" wrote: I have typed a value (1500) into cell A5. I have typed a simple formula in another cell (B5). The formula was =A5*2. When I then changed the value in A5 to 1000 the value in B5 didn't change. Why is this? I have just started using Vista and used to do a lot of formulas before and never had this problem. How do I solve it? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
reference cell
Thanks a lot. It worked!
"Mike H" wrote: Given that it calculated correctly when you first entered the formula this is a longshot but try:- Tools|Options|calculation and make sure it's set to automatic. Mike "Susie" wrote: I have typed a value (1500) into cell A5. I have typed a simple formula in another cell (B5). The formula was =A5*2. When I then changed the value in A5 to 1000 the value in B5 didn't change. Why is this? I have just started using Vista and used to do a lot of formulas before and never had this problem. How do I solve it? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
reference cell
Hi,
Do the following: 1. On the Tools menu, click Options 2. Click the calculation Tab. 3. Under Calculation, click to select the automatic check box. 4. Click OK Note: After completing the above procedure, if you click and the drag the selected cell handle below, all other cell will have the relative reference to its value in the adjacent cell. Which means, if enter a value to the left of the each refernced cell the value will have the corresponding product computed. Challa Prabhu "Susie" wrote: I have typed a value (1500) into cell A5. I have typed a simple formula in another cell (B5). The formula was =A5*2. When I then changed the value in A5 to 1000 the value in B5 didn't change. Why is this? I have just started using Vista and used to do a lot of formulas before and never had this problem. How do I solve it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |