Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
hyperlink in Word to point to a sheet in excel 1
- Thread starter pronate
- Start date
-
1
- #2
TonyJollans
Programmer
Hi pronate,
The default is not necessarily Sheet1, but to control where you go, edit your hyperlink and append # followed by the cell address you want, for example:
C:\My Documents\Book1.xls#Sheet3!A1
Note that you must provide a valid cell reference, Sheet3 by itself will give an error.
Enjoy,
Tony
The default is not necessarily Sheet1, but to control where you go, edit your hyperlink and append # followed by the cell address you want, for example:
C:\My Documents\Book1.xls#Sheet3!A1
Note that you must provide a valid cell reference, Sheet3 by itself will give an error.
Enjoy,
Tony
- Status
Similar threads
- Locked
- Question
- Locked
- Question