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
--
eva cheng

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

"eva cheng" wrote in message
...
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
--
eva cheng

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.
--
David Biddulph

"eva cheng" wrote in message
...
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
--
eva cheng

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

InsertHyperlinkExisting File or Web Page

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


Gord Dibben MS Excel MVP

On Fri, 27 Nov 2009 19:21:01 -0800, eva cheng
wrote:

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