Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data not updating
Hi, I have a problem with my formulas not updating to the correct value. for
example i have 1 in col A and 2 in col B, and col C = A*B=2. The problem is that say I change col B to 5, Col C will still remain at 2. It will also still remain at 2 if i drop down the formula again. The only way that it will update is when you actually go into the formula click at the end of it and hit enter. At that point it will update to the correct value. I'm just wondering if there is a way to update all these formulas so that this does not happen and so I don't have to manually go through all of the formulas. Thanks, Josh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating external data sheet causes loss of data on linked pages | Excel Worksheet Functions | |||
Updating data... | Excel Discussion (Misc queries) | |||
Updating data into one spreadsheet from another | Excel Discussion (Misc queries) | |||
Updating External Data | Excel Discussion (Misc queries) |