Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel doesn't update cells
If I type in 1 in A1 and 2 in A2, then type =A1+A2 in A3, the result
is 2. But if I change A1 to, say, 5, the new sum should be 6. But it remains unchanged as 2. It is not due to the options being set to manual calculation and it only does it occasionally. F9 does not change/update the cell(s). Only solution is to press F2 and enter for each and every cell, or reboot - a few times. Is my spreadsheet just too big? If so, what else can I do without reducing the file size? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel doesn't update cells
Try selecting all the cells
edit|replace what: = (equal sign) with: = (equal sign) replace all Then test it out to see if excel woke up. wrote: If I type in 1 in A1 and 2 in A2, then type =A1+A2 in A3, the result is 2. But if I change A1 to, say, 5, the new sum should be 6. But it remains unchanged as 2. It is not due to the options being set to manual calculation and it only does it occasionally. F9 does not change/update the cell(s). Only solution is to press F2 and enter for each and every cell, or reboot - a few times. Is my spreadsheet just too big? If so, what else can I do without reducing the file size? Thanks. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel doesn't update cells
On 13 Jun, 14:32, Dave Peterson wrote:
Try selecting all the cells edit|replace what: = (equal sign) with: = (equal sign) replace all Then test it out to see ifexcelwoke up. wrote: If I type in 1 in A1 and 2 in A2, then type =A1+A2 in A3, the result is 2. But if I change A1 to, say, 5, the new sum should be 6. But it remains unchanged as 2. It is not due to the options being set to manual calculation and it only does it occasionally. F9 does not change/updatethe cell(s). Only solution is to press F2 and enter for each and every cell, or reboot - a few times. Is my spreadsheet just too big? If so, what else can I do without reducing the file size? Thanks. -- Dave Peterson wow, it found 48511 replacements to make, but after days of trying to refresh - success! MANY thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i want to update one excel file the other one update automaticaly | New Users to Excel | |||
Linked cells don't automatically update in Excel 2003. Why? | Excel Worksheet Functions | |||
Cells don't update!! | Excel Discussion (Misc queries) | |||
How do I link a row of cells in wks 1 to update diff cells wks 2 | Excel Worksheet Functions | |||
Automatically update cells | Excel Discussion (Misc queries) |