How do I get links in PowerPoint to consistently link with specific tabs in Excel
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I am having a problem getting some links in PowerPoint to consistently link with specific tabs in Excel.
I am preparing a PowerPoint presentation with links in a flowchart that links to a specific tab in Excel Worksheet. I have successfully done this with one link "Zoom" using the hyperlink formula Tools%20for%20SCTrn.xlsx#Zoom
(See screenshots) Zoom Links in PPT to Excel
Zoom tab Outcome
However, when I tried to use the same formula for TeamViewer link in my PowerPoint-specifically Tools%20for%20SCTrn.xlsx#TeamViewer that pathway did not work as I didn't get the results I wanted of linking to the TeamViewer tab in my Excel Workbook, but instead was taken to the YouTube tab with an error message that reference isn't valid, which is confusing in of itself.(See screenshots) TeamViewer Links in PPT to Excel
TeamViewer tab Outcome
I have removed the links and repeated the process several times but still not successful as I keep getting the You Tube tab and error message, even when I try other hyperlinks. I am not a coder, so don't know if visual basic programming is the culprit putting a code in that is interfering with the linking process but I am interested in learning what is going on as I will be doing more presentation like this in the future and would like to find a resolution. Ideally, if anyone is out there that can tell me what I need to do to get a fix soon,I would appreciate it as the presentation is this Monday 3-4th-2019. I can come up with some workaround but it would be great to know what to do as this issue will come up again. Thanks to anyone who can help.
microsoft-excel
asked Mar 2 at 1:02
Merrill RobertsMerrill Roberts
12
add a comment |
I am having a problem getting some links in PowerPoint to consistently link with specific tabs in Excel.
I am preparing a PowerPoint presentation with links in a flowchart that links to a specific tab in Excel Worksheet. I have successfully done this with one link "Zoom" using the hyperlink formula Tools%20for%20SCTrn.xlsx#Zoom
(See screenshots) Zoom Links in PPT to Excel
Zoom tab Outcome
However, when I tried to use the same formula for TeamViewer link in my PowerPoint-specifically Tools%20for%20SCTrn.xlsx#TeamViewer that pathway did not work as I didn't get the results I wanted of linking to the TeamViewer tab in my Excel Workbook, but instead was taken to the YouTube tab with an error message that reference isn't valid, which is confusing in of itself.(See screenshots) TeamViewer Links in PPT to Excel
TeamViewer tab Outcome
I have removed the links and repeated the process several times but still not successful as I keep getting the You Tube tab and error message, even when I try other hyperlinks. I am not a coder, so don't know if visual basic programming is the culprit putting a code in that is interfering with the linking process but I am interested in learning what is going on as I will be doing more presentation like this in the future and would like to find a resolution. Ideally, if anyone is out there that can tell me what I need to do to get a fix soon,I would appreciate it as the presentation is this Monday 3-4th-2019. I can come up with some workaround but it would be great to know what to do as this issue will come up again. Thanks to anyone who can help.
microsoft-excel
asked Mar 2 at 1:02
Merrill RobertsMerrill Roberts
12
Welcome to SuperUser! The two images in your post are the same, so it is difficult to see what results that you are trying to compare. Please edit your post instead of adding information in a comment.
– Rey Juna
Mar 2 at 1:13
add a comment |
I am having a problem getting some links in PowerPoint to consistently link with specific tabs in Excel.
I am preparing a PowerPoint presentation with links in a flowchart that links to a specific tab in Excel Worksheet. I have successfully done this with one link "Zoom" using the hyperlink formula Tools%20for%20SCTrn.xlsx#Zoom
(See screenshots) Zoom Links in PPT to Excel
Zoom tab Outcome
However, when I tried to use the same formula for TeamViewer link in my PowerPoint-specifically Tools%20for%20SCTrn.xlsx#TeamViewer that pathway did not work as I didn't get the results I wanted of linking to the TeamViewer tab in my Excel Workbook, but instead was taken to the YouTube tab with an error message that reference isn't valid, which is confusing in of itself.(See screenshots) TeamViewer Links in PPT to Excel
TeamViewer tab Outcome
I have removed the links and repeated the process several times but still not successful as I keep getting the You Tube tab and error message, even when I try other hyperlinks. I am not a coder, so don't know if visual basic programming is the culprit putting a code in that is interfering with the linking process but I am interested in learning what is going on as I will be doing more presentation like this in the future and would like to find a resolution. Ideally, if anyone is out there that can tell me what I need to do to get a fix soon,I would appreciate it as the presentation is this Monday 3-4th-2019. I can come up with some workaround but it would be great to know what to do as this issue will come up again. Thanks to anyone who can help.
microsoft-excel
asked Mar 2 at 1:02
Merrill RobertsMerrill Roberts
12
I am having a problem getting some links in PowerPoint to consistently link with specific tabs in Excel.
I am preparing a PowerPoint presentation with links in a flowchart that links to a specific tab in Excel Worksheet. I have successfully done this with one link "Zoom" using the hyperlink formula Tools%20for%20SCTrn.xlsx#Zoom
(See screenshots) Zoom Links in PPT to Excel
Zoom tab Outcome
However, when I tried to use the same formula for TeamViewer link in my PowerPoint-specifically Tools%20for%20SCTrn.xlsx#TeamViewer that pathway did not work as I didn't get the results I wanted of linking to the TeamViewer tab in my Excel Workbook, but instead was taken to the YouTube tab with an error message that reference isn't valid, which is confusing in of itself.(See screenshots) TeamViewer Links in PPT to Excel
TeamViewer tab Outcome
I have removed the links and repeated the process several times but still not successful as I keep getting the You Tube tab and error message, even when I try other hyperlinks. I am not a coder, so don't know if visual basic programming is the culprit putting a code in that is interfering with the linking process but I am interested in learning what is going on as I will be doing more presentation like this in the future and would like to find a resolution. Ideally, if anyone is out there that can tell me what I need to do to get a fix soon,I would appreciate it as the presentation is this Monday 3-4th-2019. I can come up with some workaround but it would be great to know what to do as this issue will come up again. Thanks to anyone who can help.
microsoft-excel
microsoft-excel
asked Mar 2 at 1:02
Merrill RobertsMerrill Roberts
12
asked Mar 2 at 1:02
Merrill RobertsMerrill Roberts
12
edited Mar 2 at 2:23
Merrill Roberts
asked Mar 2 at 1:02
Merrill RobertsMerrill Roberts
12
asked Mar 2 at 1:02
Merrill RobertsMerrill Roberts
12
asked Mar 2 at 1:02
Merrill RobertsMerrill Roberts
12
12
Welcome to SuperUser! The two images in your post are the same, so it is difficult to see what results that you are trying to compare. Please edit your post instead of adding information in a comment.
– Rey Juna
Mar 2 at 1:13
add a comment |
Welcome to SuperUser! The two images in your post are the same, so it is difficult to see what results that you are trying to compare. Please edit your post instead of adding information in a comment.
– Rey Juna
Mar 2 at 1:13
Welcome to SuperUser! The two images in your post are the same, so it is difficult to see what results that you are trying to compare. Please edit your post instead of adding information in a comment.
– Rey Juna
Mar 2 at 1:13
Welcome to SuperUser! The two images in your post are the same, so it is difficult to see what results that you are trying to compare. Please edit your post instead of adding information in a comment.
– Rey Juna
Mar 2 at 1:13
add a comment |
1 Answer
1
active
oldest
votes
Process: Assign a name to a cell so you can reference it in the PowerPoint hyperlink
In Excel:
1) Select a cell in the Excel sheet
2) Click Formulas | Defined names | Define name
3) Type a name (like TeamViewer)
4) Click "Ok"
In PowerPoint:
1) Select the shape you want to assign the hyperlink to
2) Click Insert | Links | Link
3) Type the address / browse to the excel file and select it
4) At the end of the address add the # symbol and the name you defined in step 3 of the "In Excel" process
5) Click "Ok"
Give it a try
answered Mar 2 at 1:47
Ricardo DiazRicardo Diaz
1011
Thank Ricardo - your techniques worked - having now done this 6 times getting the same results, I have the consistently I was looking for. The key that I wasn't doing was defining the cell, instead I simply writing in the tab name in the hyperlink pathway, which wasn't correct. That is what's important. Thanks again.
– Merrill Roberts
Mar 2 at 6:11
Great, please consider marking this answer
– Ricardo Diaz
Mar 2 at 13:43
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1410632%2fhow-do-i-get-links-in-powerpoint-to-consistently-link-with-specific-tabs-in-exce%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Process: Assign a name to a cell so you can reference it in the PowerPoint hyperlink
In Excel:
1) Select a cell in the Excel sheet
2) Click Formulas | Defined names | Define name
3) Type a name (like TeamViewer)
4) Click "Ok"
In PowerPoint:
1) Select the shape you want to assign the hyperlink to
2) Click Insert | Links | Link
3) Type the address / browse to the excel file and select it
4) At the end of the address add the # symbol and the name you defined in step 3 of the "In Excel" process
5) Click "Ok"
Give it a try
answered Mar 2 at 1:47
Ricardo DiazRicardo Diaz
1011
Thank Ricardo - your techniques worked - having now done this 6 times getting the same results, I have the consistently I was looking for. The key that I wasn't doing was defining the cell, instead I simply writing in the tab name in the hyperlink pathway, which wasn't correct. That is what's important. Thanks again.
– Merrill Roberts
Mar 2 at 6:11
Great, please consider marking this answer
– Ricardo Diaz
Mar 2 at 13:43
add a comment |
Process: Assign a name to a cell so you can reference it in the PowerPoint hyperlink
In Excel:
1) Select a cell in the Excel sheet
2) Click Formulas | Defined names | Define name
3) Type a name (like TeamViewer)
4) Click "Ok"
In PowerPoint:
1) Select the shape you want to assign the hyperlink to
2) Click Insert | Links | Link
3) Type the address / browse to the excel file and select it
4) At the end of the address add the # symbol and the name you defined in step 3 of the "In Excel" process
5) Click "Ok"
Give it a try
answered Mar 2 at 1:47
Ricardo DiazRicardo Diaz
1011
Thank Ricardo - your techniques worked - having now done this 6 times getting the same results, I have the consistently I was looking for. The key that I wasn't doing was defining the cell, instead I simply writing in the tab name in the hyperlink pathway, which wasn't correct. That is what's important. Thanks again.
– Merrill Roberts
Mar 2 at 6:11
Great, please consider marking this answer
– Ricardo Diaz
Mar 2 at 13:43
add a comment |
Process: Assign a name to a cell so you can reference it in the PowerPoint hyperlink
In Excel:
1) Select a cell in the Excel sheet
2) Click Formulas | Defined names | Define name
3) Type a name (like TeamViewer)
4) Click "Ok"
In PowerPoint:
1) Select the shape you want to assign the hyperlink to
2) Click Insert | Links | Link
3) Type the address / browse to the excel file and select it
4) At the end of the address add the # symbol and the name you defined in step 3 of the "In Excel" process
5) Click "Ok"
Give it a try
answered Mar 2 at 1:47
Ricardo DiazRicardo Diaz
1011
Process: Assign a name to a cell so you can reference it in the PowerPoint hyperlink
In Excel:
1) Select a cell in the Excel sheet
2) Click Formulas | Defined names | Define name
3) Type a name (like TeamViewer)
4) Click "Ok"
In PowerPoint:
1) Select the shape you want to assign the hyperlink to
2) Click Insert | Links | Link
3) Type the address / browse to the excel file and select it
4) At the end of the address add the # symbol and the name you defined in step 3 of the "In Excel" process
5) Click "Ok"
Give it a try
answered Mar 2 at 1:47
Ricardo DiazRicardo Diaz
1011
answered Mar 2 at 1:47
Ricardo DiazRicardo Diaz
1011
answered Mar 2 at 1:47
Ricardo DiazRicardo Diaz
1011
answered Mar 2 at 1:47
Ricardo DiazRicardo Diaz
1011
1011
Thank Ricardo - your techniques worked - having now done this 6 times getting the same results, I have the consistently I was looking for. The key that I wasn't doing was defining the cell, instead I simply writing in the tab name in the hyperlink pathway, which wasn't correct. That is what's important. Thanks again.
– Merrill Roberts
Mar 2 at 6:11
Great, please consider marking this answer
– Ricardo Diaz
Mar 2 at 13:43
add a comment |
Thank Ricardo - your techniques worked - having now done this 6 times getting the same results, I have the consistently I was looking for. The key that I wasn't doing was defining the cell, instead I simply writing in the tab name in the hyperlink pathway, which wasn't correct. That is what's important. Thanks again.
– Merrill Roberts
Mar 2 at 6:11
Great, please consider marking this answer
– Ricardo Diaz
Mar 2 at 13:43
Thank Ricardo - your techniques worked - having now done this 6 times getting the same results, I have the consistently I was looking for. The key that I wasn't doing was defining the cell, instead I simply writing in the tab name in the hyperlink pathway, which wasn't correct. That is what's important. Thanks again.
– Merrill Roberts
Mar 2 at 6:11
Thank Ricardo - your techniques worked - having now done this 6 times getting the same results, I have the consistently I was looking for. The key that I wasn't doing was defining the cell, instead I simply writing in the tab name in the hyperlink pathway, which wasn't correct. That is what's important. Thanks again.
– Merrill Roberts
Mar 2 at 6:11
Great, please consider marking this answer
– Ricardo Diaz
Mar 2 at 13:43
Great, please consider marking this answer
– Ricardo Diaz
Mar 2 at 13:43
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1410632%2fhow-do-i-get-links-in-powerpoint-to-consistently-link-with-specific-tabs-in-exce%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Welcome to SuperUser! The two images in your post are the same, so it is difficult to see what results that you are trying to compare. Please edit your post instead of adding information in a comment.
– Rey Juna
Mar 2 at 1:13