link to another document of Excel 2003

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
 
F

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Highlighting duplicates 0
link to a specific worksheet of a workbook with many worksheets 1
Using cell as worksheet reference (macro) 1
How to create absolue path link to another workbook (Excel 2003) 1
Link cell from Wkbk1 to a cell in a specific Worksht in Wkbk2 4
Linking worksheets, rearranging rows. 1
Find cell in Excel2000 workbook with link from another workbook? 1

Top