| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linked cells won't update
Several workbooks have refused to update linked cells at random. Closing and
reopening doesn't update links. Only recreating the link seems to work. This has occurred on various computers, with various workbooks. Has anyone experienced this and found a cause? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linked cells won't update
Have you tried going to the EDIT menu LINKS and then clicking on the STARTUP
PROMPT? "Greg Wetzel" wrote: Several workbooks have refused to update linked cells at random. Closing and reopening doesn't update links. Only recreating the link seems to work. This has occurred on various computers, with various workbooks. Has anyone experienced this and found a cause? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linked cells won't update
Greg,
You may have calculation set to manual. Go to Tools = Options = Calculation [tab] = Automatic. Ewan. "Greg Wetzel" wrote: Several workbooks have refused to update linked cells at random. Closing and reopening doesn't update links. Only recreating the link seems to work. This has occurred on various computers, with various workbooks. Has anyone experienced this and found a cause? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linked cells won't update
No, edit, startup doesn't work and link update is set to auromatic. Links
can also be within the same workbook on another sheet with this problem. "diana" wrote: Have you tried going to the EDIT menu LINKS and then clicking on the STARTUP PROMPT? "Greg Wetzel" wrote: Several workbooks have refused to update linked cells at random. Closing and reopening doesn't update links. Only recreating the link seems to work. This has occurred on various computers, with various workbooks. Has anyone experienced this and found a cause? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked cells show wrong number | Links and Linking in Excel | |||
| Linking cells: open source to update values | Excel Discussion (Misc queries) | |||
| 0 in linked cells when watched | Excel Worksheet Functions | |||
| linked cells | Excel Discussion (Misc queries) | |||
| Two spreadsheets linked - moving cells | Excel Discussion (Misc queries) | |||
Linear Mode
