Excel Help

[merty-b-]

I am trying to add hyperlinks between to Workbooks. At the moment I am putting the Hyperlinks in one at a time and at this rate it will take me weeks. I was wondering if this is any quick way around this?

 

[scousemanc]

Copy/Paste?

 

[merty-b-]

If you copy and past it won't link to another workbook.

I would like it so you click one of the cells in Book A and it takes you to a cell in Book B

 

[scousemanc]

If you use hyperlink it just opens the file at the cell you last saved the file. Don't think you can specify a different cell.

 

[scousemanc]

I think I've got it.
Insert hyperlink in the normal way then edit the hyperlink and add an exclamation mark and the cell reference. Ive just tried it and it works eg:

Filename.xls!D7 takes you to the cell D7

 

[merty-b-]

I think I've got it.
Insert hyperlink in the normal way then edit the hyperlink and add an exclamation mark and the cell reference. Ive just tried it and it works eg:

Filename.xls!D7 takes you to the cell D7

Yeh. I cracked that part. You can also right click in the cells and go to Hyperlink and in this document but I have got about 800 cells to do and can't be @rsed going through all of them.

 

[scousemanc]

You can copy the hyperlink down the column by left clicking on the cell handle and dragging down. The reference of the hyperlink then increases incrementally. You are effectively filling a series. So in the above example the cells are filled with Filename.xls!D7, Filename.xls!D8, Filename.xls!D9 etc. This avoids the need to do them individually.

 

[scousemanc]

It doesn't work and I don't understand why. It still takes you to the original cell.

 

[merty-b-]

Tried that and didn't work for me either. Im just going to leave it just now. My head is burst like. Thank you for your help tho.

 

[Prestwich_Blue]

When you say hyper-links do you mean linking cells in two separate workbooks so that one always updates when the linked cell changes?

I've done this before (in Office 2003) and it worked and just tried it again (in Office 2007) to confirm and there is an issue but it's easily resolved.

The problem is that it "fixes" the first cell you reference by putting a $ sign in front of the row and column. (e.g. $a$1) This means the row and column stay constant when you copy and paste it so it always points at the original cell.

The solution is to copy and paste the first cell to the second workbook, remove the dollar signs then copy and paste on the second workbook and it will copy the relative cell address.

 

[Anonymous]

You'll gat all the help you need here...

<a class="postlink" href="http://www.excelforum.com/" onclick="window.open(this.href);return false;">http://www.excelforum.com/</a>