Hyperlinking from Word to a specific cell in Excel worksheet - can it be done?

  • Thread starter Thread starter ChuckS
  • Start date Start date
C

ChuckS

I have a Word table that has hyperlinks to corresponding Excel
workbooks. I have hyperlinks that take me to the Excel file, but what
I need is for the hyperlink to take me to a specific cell in specific
Excel worksheets. Rght now all the hyperlink does is take me to the
last view of the spreadsheet when it was last saved and closed.

Is there a way to do this from Word? BTW I have Word 2002 and Excel
2002. Thanks is advance.
 
Hi ChuckS

Here's how to link from a Word document to an Excel document.

You need to create a hyperlink in your Word document, like the following
examples. Note that you can't type the { } by hand. You
must do ctrl-F9 and type between the brackets. Then Alt-F9 to display
the result.

Go to an absolute address
{ HYPERLINK "C:\\MyDocuments\\MyExcelFile.xls#SheetName!A1" }

Go to a worksheet range name
{ HYPERLINK "C:\\MyDocuments\\MyExcelFile2.xls#'Sheet 1'!RangeName" }

Go to a workbook range name
{ HYPERLINK "C:\\MyDocuments\\MyExcelFile3.xls#RangeName" }

So you can go to a workbook-wide range name, or to a sheet-specific
range name. But Excel gets confused if you have both in the
Excel file, and it chooses seemingly randomly. So, if you use range
names, make sure they're all sheet-specific or all
workbook-wide. Or use an absolute address.

Note that if the sheet name contains spaces (eg 'Sheet 1'), then you
must enclose the sheet name in single quotes.

You can also use the \l (lowercase L) switch to specify the location in
the Excel file to go to, in the form:
{ HYPERLINK "C:\\MyDocuments\\MyExcelFile2.xls" \l "'Sheet 1'!A1" }

See Word's Help file under Hyperlink Field for more info and more
switches.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word
Melbourne, Australia
 
I have a Word table that has hyperlinks to corresponding Excel
workbooks. I have hyperlinks that take me to the Excel file, but what
I need is for the hyperlink to take me to a specific cell in specific
Excel worksheets. Rght now all the hyperlink does is take me to the
last view of the spreadsheet when it was last saved and closed.

Is there a way to do this from Word? BTW I have Word 2002 and Excel
2002. Thanks is advance.
Click to expand...

If, for example, your target cell was C14 in Sheet1, edit your
hyperlink to append #Sheet1!C14 immediately after the .xls so that it
reads: C:\[path]\my spreadsheet.xls#Sheet1!C14 (If you edit via the
toggled field code, it should read <HYPERLINK "C:\\[path]\\my
spreadsheet.xls" \l "Sheet1!C14">)

HTH

hro
 
Hi Chuck,

Attempting to 'bump' your post to the top is considered poor
netiquette in the newsgroups just as cutting in line at the movie
theatre is poor etiquette. :-)

If anything it can prevent you from obtaining the answer you are
seeking. Everyone's post is equally important and if everyone
attemptted to do the same the groups would be a traffic nightmare!

Also, FWIW WordForums.com is *not* a private forum. They slurp the
posts from the public newsgroups (Usenet) which can be accessed from a
various web sites and newsreaders. For example if you use Outlook
Express this link will start OE and add this newsgroup for you:
news://msnews.microsoft.com/microsoft.public.word.newusers

Not to mention you'll find posts and answers appear in minutes where
I've noticed it may take hours for answers to appear in
WordForums.com! I suspect could be part of the problem here. You've
recieved a few replies to your question, one of which is the answer
you seek - posted 6 hours before this one, and it looks like they have
yet to appear on WordForms.com.

Additionally the majority of newsreaders and other web interfaces
designed to access the newsgroups do not place the most recent post at
the top. Instead it is added as another post in the same thread. IOW,
your recent post did not change the position of your original post on
my end.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
Back
Top