link to another document of Excel 2003

  • Thread starter Thread starter eva cheng
  • Start date Start date
E

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
 
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
 
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
 
Back
Top