trying to link data between workbooks and worksheets

  • Thread starter Thread starter Easydoesit
  • Start date Start date
E

Easydoesit

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.
 
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?
: 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.
:
:
 
What if there is no formula involved? It only speaks about an = if there is
a formula.
 
Back
Top