EXCEL 2003 When trying 2 link 2 pages from different workbooks I can only get
cell A1 to come to the destination workbook. Help. Ema

what is the procedure you are using to link?

"Ema" wrote:

EXCEL 2003 When trying 2 link 2 pages from different workbooks I can only get
cell A1 to come to the destination workbook. Help. Ema

open both wkbooks, save destination book, have other sheet of wkbook open,
enter equal sign in ?address line of destination bk and click on top left
corner of source sheet. I get a formula but only the A1 cell comes over ????

"bj" wrote:

what is the procedure you are using to link?

"Ema" wrote:

EXCEL 2003 When trying 2 link 2 pages from different workbooks I can only get
cell A1 to come to the destination workbook. Help. Ema

If you are trying to pull information from one cell of the source sheet to
one cell of the destination sheet, then that's what you've got. It should
look something like:
='[Sourcebookname.xls]Source sheet name'!A1. If it includes $ signs for
absolute addressing, such as $A$1, then you probably want to remove those if
you want to copy the formula to other cells as below.

Having ensured that you've got relative rather than absolute addressing,
then if you wish to do something equivalent for other cells on the sheet,
then merely copy your destination cell across as many rows and column as
applicable.

If you are trying to pull information from a range on the source sheet to a
cell in the destination sheet, then when you've instered an appropriate
formula in the destination sheet you can select the relevant range from the
source sheet, such as:
=AVERAGE('[Sourcebookname.xls]Source sheet name'!$A$1:$D$8)
--
David Biddulph

"Ema" wrote in message
...
open both wkbooks, save destination book, have other sheet of wkbook open,
enter equal sign in ?address line of destination bk and click on top left
corner of source sheet. I get a formula but only the A1 cell comes over
????

"bj" wrote:

what is the procedure you are using to link?

"Ema" wrote:

EXCEL 2003 When trying 2 link 2 pages from different workbooks I can
only get
cell A1 to come to the destination workbook. Help. Ema

Try an alternate method to link all cells you want.

Select a range of cells in book1......say A1:D20

Copy then switch to book2 and select a cell.

EditPaste SpecialPaste LinkOKEsc


Gord Dibben MS Excel MVP


On Thu, 23 Aug 2007 05:34:00 -0700, Ema wrote:

open both wkbooks, save destination book, have other sheet of wkbook open,
enter equal sign in ?address line of destination bk and click on top left
corner of source sheet. I get a formula but only the A1 cell comes over ????

"bj" wrote:

what is the procedure you are using to link?

"Ema" wrote:

EXCEL 2003 When trying 2 link 2 pages from different workbooks I can only get
cell A1 to come to the destination workbook. Help. Ema

David, I checked the formula, It didn't have the parentheses, I added them. I
still cannot get the whole range. Only A1 is coming over. I have tried this
now on 3 different computers. I must be doing something wrong.
I am saving the destination (blank) workbook sheet. putting the equal sign
in the address line (which puts it in the a1 cell) then going to other
workbook and sheet, I've tried highlighting the entire range, typing the
entire range, clicking on the top left corner of the page, the formula in the
destination page looks OK. Any other ideas?

"Ema" wrote:

open both wkbooks, save destination book, have other sheet of wkbook open,
enter equal sign in ?address line of destination bk and click on top left
corner of source sheet. I get a formula but only the A1 cell comes over ????

"bj" wrote:

what is the procedure you are using to link?

"Ema" wrote:

EXCEL 2003 When trying 2 link 2 pages from different workbooks I can only get
cell A1 to come to the destination workbook. Help. Ema

copy the A1 cell in the destination sheet and paste it wherever you want
information to show.
the procedure you used will only activate the A! cell

"Ema" wrote:

open both wkbooks, save destination book, have other sheet of wkbook open,
enter equal sign in ?address line of destination bk and click on top left
corner of source sheet. I get a formula but only the A1 cell comes over ????

"bj" wrote:

what is the procedure you are using to link?

"Ema" wrote:

EXCEL 2003 When trying 2 link 2 pages from different workbooks I can only get
cell A1 to come to the destination workbook. Help. Ema