Ask Your Question
0

Easiest way to link cells in different spreadsheets? [closed]

asked 2012-10-06 21:33:44 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have two spreadsheets. A cell in one of them needs to contain the same dollar amount as a cell in the other one and to be automatically updated when the first one changes. I've tried the instructions in the Help file but they don't seem to work. What is the easiest way to establish this link?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 04:35:30.822502

1 Answer

Sort by » oldest newest most voted
0

answered 2012-10-06 23:55:37 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Once a link is established between spreadsheets it appears that the link will not be updated unless a) the source spreadsheet is saved and b) either the target spreadsheet is set to update automatically (with a time that can be specified) or the target spreadsheet is closed and reopened and the Update Links question answered affirmatively or the link is updated manually.

edit flag offensive delete link more

Comments

We cannot get a link to alter in another spreadshet when we alter the original cell which is linked to it

JO'DONNELL gravatar imageJO'DONNELL ( 2017-12-24 15:25:26 +0100 )edit

Question Tools

Stats

Asked: 2012-10-06 21:33:44 +0100

Seen: 307 times

Last updated: Oct 06 '12