hyperlinking files

[fullymooned]

I need to hyperlink a cell to another excel file. However instead o
merely hyperlinking I need to link it to a particular tab in the file.

Workbook1.xls#Sheet1!A5 doesnt work it says refecence is not valid


Thank yo

 

[Dave Peterson]

How about one of these that David McRitchie has posted:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

 

[Dave Hawley]

Hi

You should only need to supply the file path, eg

C:\Ozgrid Likom\Testings\Book5.xls#Sheet3!A1

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Dave Hawley]

Oops looks like the path seperator ("\") is removed when posting

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****