Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
Linking Word and Excel
Hi all, This seems to be an easy bet for most of the Excel users, but it is really not for me. I created a Word file. Now i want to put a hyperlink to the SECOND work-sheet of another excel file, which is saved in same folder. Can anyone tell me how to do that? Thanks and regards, Arun Kumar Saha Hyderabad, INDIA -- arrun |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
Linking Word and Excel
in Word press Ctrl-k (Control ank K keys at the same time).
select the "Link to:" option in the left pane and choose "Existing File or Web Page" enter the following text in the "Address:" WorksheetName.xls#'sheet2'!A1 Replace WorksheetName.xls with your file name Replace sheet2 with your workbook name Note that sheet2 the worksheet name (ie sheet2) is enclosed in single quotes. There is an exclamation point ( above your number one) between the sheet name and the cell reference. A1 in the cell that will appear in the top left corner so you can open to any point in the workbook by just changing the reference point. It doesn't always open the specified reference point at the top left of the screen, so you may have to experiment to get the effect you want. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Word and Excel | Links and Linking in Excel | |||
Embedding or Linking (?) Excel in Word | Excel Discussion (Misc queries) | |||
vba linking Excel and Word | Excel Worksheet Functions | |||
linking excel to word | New Users to Excel | |||
Linking Excel and Word | New Users to Excel |