As long as you re-sum the column when you add the new row, the link should
update automatically. If you want a link to reference a static cell reference
that won't change, you would put a $ sign in front of the row number and
column letter (ex. $A$1)
Hope this helps.

"Greg" wrote:

I'm not sure what you mean. Say I have a sum function in H10 I add a row
above it so the total is now in H11. will my link in the other book update to
H11 or do i have to reassign it?
--
Greg



"Anna" wrote:

Are you needing to be linked to the same cell? or do you need the link to
stay with the column total it was initially linked to?

"Greg" wrote:

I have one workbook that new rows are added to when a new job is bid. I want
to link to a cell with the total that will be at the bottom. What will happen
when a new row is added? I need it to stay on the total value.
--
Greg