minus signs, or dashes in a formula or hyperlink

F

Flipper

=HYPERLINK("file:///W:\Courtney\Recon\LnRec-8-09.xls#2003-N!A1","September
2009 Reconciliation")

The above is obvisouly a hyperlink; however, the formula is not functioning
properly. It does take me to the worksheet "2003-N" but instead of "landing"
in cell A1, it lands in cell B32. Additionally, I receive an error message
that says the reference is not valid. This also happens with any sheet that
is named with a dash or minus sign in the name. I feel certain it has to do
with that dash, as the formula works perfectly with worksheets that have no
dashes/minus signs in the name.
Can anyone assist me?

Thanks
 
L

Luke M

I believe you need to place brackets around file name, to sepearate from
sheet name.

=HYPERLINK("[W:\Courtney\Recon\LnRec-8-09.xls]2003-N!A1","September
2009 Reconciliation")

Note that I'm assuming your sheet is actually named "2003-N", not "#2003-N".
 
F

Flipper

Thanks Luke, but that does not work.
--
Allan


Luke M said:
I believe you need to place brackets around file name, to sepearate from
sheet name.

=HYPERLINK("[W:\Courtney\Recon\LnRec-8-09.xls]2003-N!A1","September
2009 Reconciliation")

Note that I'm assuming your sheet is actually named "2003-N", not "#2003-N".

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


Flipper said:
=HYPERLINK("file:///W:\Courtney\Recon\LnRec-8-09.xls#2003-N!A1","September
2009 Reconciliation")

The above is obvisouly a hyperlink; however, the formula is not functioning
properly. It does take me to the worksheet "2003-N" but instead of "landing"
in cell A1, it lands in cell B32. Additionally, I receive an error message
that says the reference is not valid. This also happens with any sheet that
is named with a dash or minus sign in the name. I feel certain it has to do
with that dash, as the formula works perfectly with worksheets that have no
dashes/minus signs in the name.
Can anyone assist me?

Thanks
 
D

Dave Peterson

Try putting apostrophes around the sheetname:

=HYPERLINK("file:////W:\Courtney\Recon\LnRec-8-09.xls#'2003-N'!A1",
"September 2009 Reconciliation")

(I've always used 4 /'s, too. I'm not sure if that matters, but it's always
worked for me.)
 

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