Vicky has attended:
Project Intro Intermediate course
Urgent request please need answer by noon today !
I need to hyperlink from a word document to a worksheet in an excel document. how do I do this so it links to a particular worksheet ?
RE: Urgent request please need answer by noon today !
Hi Vicky,
To link from your word document to your excel file you would need to use the hyperlink function. Excel will open excel at wherever the last place you saved it was. So if you want to link to Cell A1 in Sheet 5 for example you would have to have saved you excel workbook with the screen showing Sheet 5 and the cursor in A1.
Hope that helps
Tracy
RE: Urgent request please need answer by noon today !
Thanks Tracy.
What happens though if the spreadsheet is accessed and saved to another worksheet after i have hyperlinked say to cell A1 in sheet 5? will it then open to the next place it was saved?
Vicki
RE: Urgent request please need answer by noon today !
Yes it will open to the active cell where it was saved. A good idea would be to hold the one sheet you need to link into in a separate workbook
Tracy
