Hperlink (Other workbook)

**Vinodsralian** · 07-13-2010, 07:19 AM

Hi,

I have an excel sheet named (file A) and an excel sheet named (file B).

I have to link from excel sheet cell (say A5 of file A) to file B - cell D10.

How do I go about this using hyperlink, any possible solutions??

Regards
Vinod

**Rahul Nagar** · 07-13-2010, 07:26 AM

Hi,

you can use Insert Hyperlink option.
1st go to Insert>>2nd click on Hyperlink option (shortcut ctrl+k)
click on current folder and select file A.
you can change the name in to A5 of file A from Text to display.

**Vinodsralian** · 07-13-2010, 07:31 AM

Hi, I understand the possibility of mapping in the same file. But I need to link to file B(to a specific cell, not just to a document as a whole) from file A (specific cell)

**Vinodsralian** · 07-13-2010, 02:15 PM

Can any one please let me know is there any way this could achieved.

Thanks

**pike** · 07-25-2010, 05:15 AM

hi Vinodsralian,
You can crate the hyperlink to a workbook the in the dialog box on the right select a sheet within the work book

**Vinodsralian** · 07-25-2010, 05:32 AM

Lets say in Book1/A1, I have a text named example in the cell, I do a right click on that and click on hyperlink, I would be navigated to "Insert Hyperlink" screen. From here how do I select "Book2/Sheet2/B10" is my problem. Hope I am clear!!!

**pike** · 07-25-2010, 05:36 AM

on the left hand side there is a "Place In The Document" button click that and you can select the sheet and the "cell reference"

**Vinodsralian** · 07-25-2010, 05:41 AM

Pike, "Place in the document option refers to Sheet's in the same workbook". I have attached spreadsheets with comment, let me see this may explain or get a solution to my prob