link to another document of Excel 2003

[eva cheng]

I want to insert a link in a cell of worksheet A in workbook A to a cell in
worksheet B in workbook B which contains worksheets A-D. I can only link to
workbook B and cannot link to worksheet B.

Thanks

 

[Fred Smith]

It would be useful if you showed us the formula you were using. In general,
you want the following syntax:

=[BookB]SheetB!$A$1

Regards,
Fred

 

[David Biddulph]

Open both workbooks.
Click in the destination cell in worksheet A in workbook A.
Type an = sign
Select workbook B
Select worksheet B
Click in the source cell in worksheet B; its reference will be added after
the = sign in the formula which you started in workbook A.
Now press Enter.

 

[Gord Dibben]

Are you trying to Hyperlink to a cell on a sheet in another workbook?

Insert>Hyperlink>Existing File or Web Page

Select the file then "Bookmarks" Select the sheet and cell and OK


Gord Dibben MS Excel MVP