Quick Hyperlink Function Question

mahmed1

Well-known Member
Joined
Mar 28, 2009
Messages
2,302
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hi guys

I have this formula to hyperlink to the sheet which is in D3 but its not working. Please advise where i am going wrong.
I have multiple sheets and have a data validation in cell D3 exactly the same names as the sheet names. I am trying to hyerlink to the sheet depending on what i select in D3

=HYPERLINK("[Main Copy]'"&D3&"'!B2",D3)

I get this message (Cannot open the specified File)..

Is this error because i have spaces in my sheet names? If yes how can i get round this without having to delete the spaces?

Thank You
 
Last edited:

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Hi, i have done that but i still get the same error message

=HYPERLINK("'[Main Copy]"&D3&"'!B2",D3)
 
Upvote 0
Hi guys

I have this formula to hyperlink to the sheet which is in D3 but its not working. Please advise where i am going wrong.
I have multiple sheets and have a data validation in cell D3 exactly the same names as the sheet names. I am trying to hyerlink to the sheet depending on what i select in D3

=HYPERLINK("[Main Copy]'"&D3&"'!B2",D3)

I get this message (Cannot open the specified File)..

Is this error because i have spaces in my sheet names? If yes how can i get round this without having to delete the spaces?

Thank You
Try it like this:

=HYPERLINK("#'"&D3&"'!B2",D3)
 
Upvote 0
Try it like this:

=HYPERLINK("#'"&D3&"'!B2",D3)


Biff.... In the most nicest way possible. I just want to say I love you woman. :-)

You always help me. Thank You

Can you advise why my original formula did not work and what is the syntax "#"'? That seems to be the whole trick for this to work.

Just for more info...In cell D3 i have a data validation (I have this formula...
Indirect(B3). Whatever is in B3 is Defined as named range

Thank You once again
 
Upvote 0
Biff.... In the most nicest way possible. I just want to say I love you woman. :-)

You always help me. Thank You

Can you advise why my original formula did not work and what is the syntax "#"'? That seems to be the whole trick for this to work.

Just for more info...In cell D3 i have a data validation (I have this formula...
Indirect(B3). Whatever is in B3 is Defined as named range

Thank You once again
You're welcome! :cool:

About that "pound sign"...

I know that it means to go to a specific location but I don't know why it doesn't work without it.

It's similar to a URL hyperlink.

Consider these 2 examples:

http://contextures.com/xlFunctions02.html

http://contextures.com/xlFunctions02.html#Trouble

The first one takes you to the whole page and the second one with the "pound sign" takes you to a specifc location on the same page.
 
Upvote 0

Forum statistics

Threads
1,222,312
Messages
6,165,276
Members
451,949
Latest member
bovacik

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top