Links

R

raw

Hi

Is it poss to link to a sheet in a different excel workbook even if th
workbook is closed?

Or could you have a workbook that is open but in the background & hid
(a master workbook) and both of the (2) are then linked to tha
workbook
But this would mean that it needs to open the master 1 when you clic
on of one other workbooks (1 master 2 different workbooks but need sam
data)
But then again if 1 was open + the master then you went and opened th
other you would get a message about file already open?????


Thank
 
D

Dave Peterson

It's possible to link cells between workbooks and those workbooks can be
closed. But remember that this is a one way link. You put the value in one
cell in one worksheet in one workbook and that other cell in the other worksheet
in that other workbook retrieves the value using a formula.

You can build the formula yourself (yech!!!) or you can let excel help.

Open both workbooks.
select the "sending" cell
edit|copy
off to the other worksheet (in that other workbook)
edit|paste special|click Paste Link.

You'll see what the formula looks like when the workbook is open. And if you
close that first workbook, then you'll see how the formula adjusts.

Remember that this is a one way path. You can "pull" the data from a cell using
a formula. You can't "push" the data to another cell using a formula.
 
Top