Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linked Cell Updating
I have a cell with a link formula (='Task 7'!E8 ) that doesn't update when
data changes in the source cell. When I add a dollar sign (='Task 7'!$E$8) the link update works. Why is this? Is there something out there I can read on this? Thanks, Phil |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linked Cell Updating
It works because you edited the cell. Change the source value, select the
cell, do F2, hit enter (make no changes) and it should update as well without the $ signs. To the best of my knowledge, if you have calculation set to automatic, it should update when you change the value of the source cell. -- Regards, Tom Ogilvy "Phil Hageman" wrote in message ... I have a cell with a link formula (='Task 7'!E8 ) that doesn't update when data changes in the source cell. When I add a dollar sign (='Task 7'!$E$8) the link update works. Why is this? Is there something out there I can read on this? Thanks, Phil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating linked data | Excel Discussion (Misc queries) | |||
Updating the source of a linked cell | Links and Linking in Excel | |||
Linked values not updating | Excel Worksheet Functions | |||
Updating linked workbooks | Excel Discussion (Misc queries) | |||
Linked files not updating | Excel Programming |