Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hyperlink from Word to Excel bookmark
In Office 97, I could hyperlink from Word to a bookmark in an Excel file.
I've upgraded to Office 2003. Now I cannot insert a new hyperlink to an Excel bookmark -- only to the Excel spreadsheet in general, but not directly to the bookmark. When I hit the "bookmark" button on the hyperlink dialogue says it can't open/parse that type of file (e.g., the Excel spreadsheet I'm trying to link to). The old/existing hyperlinks to an Excel bookmark still work. Any suggestions? |
#2
|
|||
|
|||
Press Alt-F9 to display field codes. Add a location switch (backslash-EL
plus bookmark name), so you code will look something like this -- { HYPERLINK "C:\\Documents and Settings\\...\\MySheet.xls" \l XL_Bookmark } Don't forget to update the field. "rawahoho" wrote in message ... In Office 97, I could hyperlink from Word to a bookmark in an Excel file. I've upgraded to Office 2003. Now I cannot insert a new hyperlink to an Excel bookmark -- only to the Excel spreadsheet in general, but not directly to the bookmark. When I hit the "bookmark" button on the hyperlink dialogue says it can't open/parse that type of file (e.g., the Excel spreadsheet I'm trying to link to). The old/existing hyperlinks to an Excel bookmark still work. Any suggestions? |
#3
|
|||
|
|||
Thanks - hadn't thought about the "brute force" method - worked great.
Curious that it no longer works the "right" way, though... "Jezebel" wrote: Press Alt-F9 to display field codes. Add a location switch (backslash-EL plus bookmark name), so you code will look something like this -- { HYPERLINK "C:\\Documents and Settings\\...\\MySheet.xls" \l XL_Bookmark } Don't forget to update the field. "rawahoho" wrote in message ... In Office 97, I could hyperlink from Word to a bookmark in an Excel file. I've upgraded to Office 2003. Now I cannot insert a new hyperlink to an Excel bookmark -- only to the Excel spreadsheet in general, but not directly to the bookmark. When I hit the "bookmark" button on the hyperlink dialogue says it can't open/parse that type of file (e.g., the Excel spreadsheet I'm trying to link to). The old/existing hyperlinks to an Excel bookmark still work. Any suggestions? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I divide a page into three sections? | Microsoft Word Help | |||
how can you create quickwords in MS Office Word 2003 | Microsoft Word Help | |||
Macro that will add the file path & date to Word footnotes? | Microsoft Word Help | |||
Word Field Codes in Excel data file | Mailmerge | |||
How do I convert a cd in word perfect to microsoft word | Microsoft Word Help |