Invalid Reference on Hyperlink to Excel Worksheet

  • Thread starter Thread starter phitchcock
  • Start date Start date
P

phitchcock

In a hyperlink field in Access, I am trying to enter a hyperlink to a
specific worksheet inside an excel workbook. I am using the following
syntax that I found online:

ClickHere#C:\Temp\Workbook.xls#'Sheet1'

When I follow the link, the workbook opens, but then I get an error
message in Excel that says 'Reference is not valid' and it does not
change to the specific sheet I listed. I've tried different workbooks
and worksheets and double checked that the names are typed correctly
but I always get the same result.

I've tried with Named Ranges and that works fine.

Does anybody know how I can get this hyperlink to work?
 
I have been working on this and here is more info...

If I include a range suffix to the sheet name it works, but only if the
sheet name is not included in quotes (because of a space in the name).

This one works...

click here#C:\Temp\Book1.xls#Sheet1!A1


When I try to enter this one, Access removes everything after the
second single quote after I leave the text box.

click here#C:\Temp\Book1.xls#'Sheet 1'!A1

becomes...

click here#C:\Temp\Book1.xls#'Sheet 1'

and then get I the same error I started with.

Is there another syntax I should be using here??

btw, I'm using Office 2003
 

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

Similar Threads

Excel Macro to hyperlink an archived worksheet to an index page 0
Excel Hyperlink in Excel to Devonthink pro File 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Hyperlink to a specific page in Excel 3
Hyperlink function question... 1
Hyperlink Help 4
Hyperlink via indirect cell reference 8
Hyperlink to a spcific worksheet 6

Back
Top