I am running Microsoft Excel and have successfully hyperlinked to documents in Microsoft Word. Is it possible once I am in Microsoft Word to hyperlink or go back to the original document in Excel? I have checked the "help" in both and have come up with nothing. Can this really be done? or am I asking to much?

To add a hyperlink in Word, type Ctrl-K or from the menu Instert > Hyperlink. This should open a dialog box allowing you to browse to the file you want to link to.

Another way.

Open the 'Web' toolbar (View - Toolbars - Web) in Word.

Then when you hyperlink into word you can just hit the 'back' button (back arrow) on the web toolbar.

Pressing the <Alt> - <Tab> keys together will toggle your active window with the one previously viewed. If you are in Word and hyperlink to Excel then want to go back to Word, just press the <Alt> / <Tab> combination. If you wanted to return to Word and close the Excel hyperlink, just close the Excel document with the "X" in the upper corner. Your Word document will still be there.

Good to see you M.G.

Dave

Heh, looks like your alt and tab didn't quite show up in your post. Must be an HTML thing...

Hmmmmm. Thanks Howste - you are right it doesn't work too well if you don't press ALT and TAB.

Thanks for catching that.

Dave

Hmmmmm. Thanks Howste - you are right it doesn't work too well if you don't press ALT and TAB.

Thanks for catching that.

DavePutting carets (>) "right" or (<) "left" [reverse order, left caret first, then right caret on other side of text to be hidden, of course] around any text makes it invisible in html.

That's why it usually pays to look at the preview closely before submitting the post. Dave's original post (reading source code) had the Alt-Tab, but with the carets on either side of "Alt" and "Tab" which hid them in html.

I double click, to highlight the word, then right click and go to hyperlink. BTW, I think hyperlinking is one of the greatest things in document control for electronic systems. In fact, I know of many companies that have set up their entire system in html. It can be made attractive (and easy) enough so everyone will use it.

Hi Guys,

I don't know if anyone has actually ansered the question properly. I understand that we want to make a document andf hyperlink between it and another document and back again. If this is so follow the tipe below:

In Excel right click on a selected (highlighted) phrase, picture etc and a then select 'hyperlink' from the drop down menu.
'Browse' for the the 'File' or document you want to hyperlink to then selct O.K.

Select the hyperlink on the excel file and this will take you to the selected document, in this case the word document you wanted.

Type a phrase or select a drawing, arrow, photo etc and right click to bring up the drop down menu and again select hyperlink. Follow the same steps as you did to get from the excele file to the word file. Now each time you selct the highlighted phrases etc you will move to the other document.

The simplest method of highlighting the Hyperlink is by using the other documents name as the link in your text. I use hyperlinking all of the time and now that I have PDF writer I will be investigating the new Bookmark tool they have in the index to hyperlink between pages of large documents etc.

I hope this helps

Greg B

Maybe I'm reading dbulak's post wrong...but what I'm hearing is this:

Would clicking on the link to the Word file...then clicking on the link back to the Excel file take you back to the original Excel file? or open up another instance of the Excel file in question?

I'm tempted to believe it will try to reload the same Excel spreadsheet again, that is...if the Word Document points its address to the filepath for the Excel file (and vice versa). If this is the case, if any changes happened to the Excel file during this process...you'd have to save it and click the links again to show the updated Excel spreadsheet. :frust:

Now I'm beginning to wonder myself... :biglaugh:

OK, so how do you delete-eliminate a hyperlink.

OK, so how do you delete-eliminate a hyperlink.
dbulak,

Hi again, If you have read my post #9 above you will hopefully be able to follow my instructions for posting a Hyperlink in Word and Excel. To remove a Hyperlink is even easier.
Right click on the Hyperlink
A drop Down Menu appears. Now select 'Hyperlink'
A Pop Up Screen appears.
In the bottom left hand corner select 'Remove'
The Hyperlink is now removed :magic:

Greg B

Greg, thanks for the info. I tried it when I got in this morning. I found that the sequence to be slightly different.

1. right click on the hyperlink.
2. pop up screen appears.
3. select "edit".
4. new menu appears.
5. bottom of menu has ''remove link''.

Could I have a different Microsoft version?

Thanks again for the help!!!!