Linking Tabs to Cells Error

pjandshelly

Board Regular
Joined
Jan 25, 2017
Messages
61
I have a worksheet that has a link to a folder. I also have a cover sheet that has values 1-38. I would like to create a link to those numbers to a tab that the value is referencing. For example, #2 is referencing appointments. I have an appointments worksheet that has a link on the page that goes to a secured folder. When I tried to create a link for #2 to tab appointments, i.e. Right click on #2 > Hyperlink> Place in this document> under Cell Reference> Choose the name that matches the tab name> click ok.

When I click on #2 , it opens that hyperlink that was on the page to the folder instead of to the Worksheet. One other thing to add, next to that number is the name of the report. That name is hyperlinked to the link of the folder that I would like to open to get to where we are saving the reports. I don't know if this is causing the issue.

Is it possible to link to that worksheet with the hyperlink on it? If so, what am I doing wrong?
 
Last edited:

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
1,830
Office Version
  1. 365
Platform
  1. Windows
When I create a hyperlink to a destination within the workbook, I select the "Place in this document" button on the left within the hyperlink dialog. It then allows me to choose the sheet name and cell location.

Is that what you're doing?

Jeff
 

pjandshelly

Board Regular
Joined
Jan 25, 2017
Messages
61
Yes. For some reason, it is pulling a folder that the name of the report is also pulling.

For example, my table would look like this:

Tab Report
1 Appointments

Appointments has a link to a folder. When I try to hyperlink 1 to the tab using this process: Right click on #1 > Hyperlink> Place in this document> under Cell Reference> Choose the name that matches the tab name> click ok; not the folder nor the report name, it links to the report.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,768
Messages
5,626,776
Members
416,202
Latest member
donya ba

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
Top