Hyperlinking from Outlook 2003 to an excel Worksheet

F

fidgitthedigit

I'm trying to insert a hyperlink in a Outlook-2003 generated e-mail to
a specific tab in a multi-sheet Spreadsheet. I have no problem getting

into the spreadsheet, but it will only go to where the file was
previously opened, and I want to be able to do this without creating
tags in the spreadsheet.

the hyperlink included in the e-mail is <file://\\mainserver\project
costs\time reporting\timesheet90995.xls> and I want to go to cell B6 in

tab April-06 directly by clicking the hyperlink in the e-mail message.


Excel seems to suggest that appending #'April-06'!B6 to the end of the
hyperlink will give me what I want, but it doesn't, the # just seems to

be a memo note.


Any suggestions?
 
W

William Lefkovics [MVP]

Do you want the hyperlink to open in a browser or in Excel?

I would just use the UNC format:
\\mainserver\projectcosts\time%20reporting\timesheet90995.xls#April06!B6
maybe %20 for the space
and no quotes around the worksheet name (use URL friendly worksheet names
within the workbook, too)

This will open it up using Excel.
 
F

fidgitthedigit

I want the hyperlink to open in Excel. I tried your suggestion (e.g.
substituting %20 for the space, etc..) and got the exact same result as
before, namely, I'm able to open the spreasheet OK, but it ignores the
bookmark reference, i.e. it opens at where the file was last opened.
In the example I provided, instead of opening at April06!B6, it opens
at May06 which is where I last modified the sheet.

There is a workaround, namely, using a transition excel file with a
built in macro that will move the cursor to the correct tab and
location in the spreadsheet, but I'm trying to avoid this intermediate
step.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top