Below is what the Excel XP Help says about linking, and it makes no sense to
me, nor does it work. How do I really link data between separate workbooks?
What I want to do is see the same information in the Destination sheet as in
the Source sheet, and keep the info current. Merely copying it won't keep it
current.
And how does Microsoft get by with writing such sloppy work?
Create a link between cells in different workbooks
1.. Open both the workbook that will contain the link (called the
destination workbook), and the workbook that contains the data you want to
link to (called the source workbook).
2.. In the destination workbook, click Save .
3.. Select a cell or cells you want to link from.
4.. If you are creating a new formula, type = (an equal sign).
If you are entering the link elsewhere in the formula, type the operator
or function that you want to precede the link.
5.. On the Window menu, click the name of the source workbook, and then
click the worksheet that contains the cells you want to link to.
6.. Select the cells you want to link to.
7.. Complete the formula. When you finish entering the formula, press
ENTER.
Lady Layla - 21 Jul 2004 15:01 GMT
What is sloppy about this? It describes exactly what you need to do -- has
nothing to do with copy or past
What don't you understand about this? You select a cell in the workbook you
want to show the data from the other workbook, enter = then move to the workbook
with the data in it, select the cell, and hit enter. Go back to the workbook
where you want to show the data and the cell in question should mirror the
original book. Hit save and close both. When you reopen the mirror file, you
will get a dialogue box that will ask if you want to update your links in case
the data in the original file has changed.
: Below is what the Excel XP Help says about linking, and it makes no sense to
: me, nor does it work. How do I really link data between separate workbooks?
[quoted text clipped - 21 lines]
: 7.. Complete the formula. When you finish entering the formula, press
: ENTER.
Easydoesit - 24 Jul 2004 02:11 GMT
What if there is no formula involved? It only speaks about an = if there is
a formula.
> What is sloppy about this? It describes exactly what you need to do -- has
> nothing to do with copy or past
[quoted text clipped - 32 lines]
> : 7.. Complete the formula. When you finish entering the formula, press
> : ENTER.