How to add a cell value in a link in Excel
I have an issue with links composition in Excel.
Lets say in cell A1 I have value of "34". In A2 I have a link to a cell in another excel file - something like "serverexcelfile_34.xls!Sheet1C12".
I would like when the value of A1 in the first file changes to "35", the link in A2 to become "serverexcelfile_35.xls!Sheet1C12".
The link is actually pulling a value from the other file. I just have hundreds of those "excelfileXX" and if "A1" = 35, only the one with 35 at the end is the right one to pull data from.
I tried concatenate but the link becomes huge >255. After separating it in different cells and then concatenated - the link was not working. No data was pulled from the external file.
Is what I need possible? Can you help?
microsoft-excel links
edited Feb 1 at 3:37
fixer1234
18.9k144982
asked Jan 31 at 18:17
Ivaylo HristovIvaylo Hristov
11
add a comment |
I have an issue with links composition in Excel.
Lets say in cell A1 I have value of "34". In A2 I have a link to a cell in another excel file - something like "serverexcelfile_34.xls!Sheet1C12".
I would like when the value of A1 in the first file changes to "35", the link in A2 to become "serverexcelfile_35.xls!Sheet1C12".
The link is actually pulling a value from the other file. I just have hundreds of those "excelfileXX" and if "A1" = 35, only the one with 35 at the end is the right one to pull data from.
I tried concatenate but the link becomes huge >255. After separating it in different cells and then concatenated - the link was not working. No data was pulled from the external file.
Is what I need possible? Can you help?
microsoft-excel links
edited Feb 1 at 3:37
fixer1234
18.9k144982
asked Jan 31 at 18:17
Ivaylo HristovIvaylo Hristov
11
What have you tried so far? What has your research shown you?
– music2myear
Jan 31 at 18:33
Concatenate doesnt work as the link becomes above 255 symbols. If I separate the link in cells and then concatenate them they just dont work as expected. At the end it doesnt show the cell value I am linking to.
– Ivaylo Hristov
Jan 31 at 19:32
Use the EDIT button to add information to the body of the question itself rather than adding this necessary information in comments.
– music2myear
Jan 31 at 19:35
add a comment |
I have an issue with links composition in Excel.
Lets say in cell A1 I have value of "34". In A2 I have a link to a cell in another excel file - something like "serverexcelfile_34.xls!Sheet1C12".
I would like when the value of A1 in the first file changes to "35", the link in A2 to become "serverexcelfile_35.xls!Sheet1C12".
The link is actually pulling a value from the other file. I just have hundreds of those "excelfileXX" and if "A1" = 35, only the one with 35 at the end is the right one to pull data from.
I tried concatenate but the link becomes huge >255. After separating it in different cells and then concatenated - the link was not working. No data was pulled from the external file.
Is what I need possible? Can you help?
microsoft-excel links
edited Feb 1 at 3:37
fixer1234
18.9k144982
asked Jan 31 at 18:17
Ivaylo HristovIvaylo Hristov
11
I have an issue with links composition in Excel.
Lets say in cell A1 I have value of "34". In A2 I have a link to a cell in another excel file - something like "serverexcelfile_34.xls!Sheet1C12".
I would like when the value of A1 in the first file changes to "35", the link in A2 to become "serverexcelfile_35.xls!Sheet1C12".
The link is actually pulling a value from the other file. I just have hundreds of those "excelfileXX" and if "A1" = 35, only the one with 35 at the end is the right one to pull data from.
I tried concatenate but the link becomes huge >255. After separating it in different cells and then concatenated - the link was not working. No data was pulled from the external file.
Is what I need possible? Can you help?
microsoft-excel links
microsoft-excel links
edited Feb 1 at 3:37
fixer1234
18.9k144982
asked Jan 31 at 18:17
Ivaylo HristovIvaylo Hristov
11
edited Feb 1 at 3:37
fixer1234
18.9k144982
asked Jan 31 at 18:17
Ivaylo HristovIvaylo Hristov
11
edited Feb 1 at 3:37
fixer1234
18.9k144982
edited Feb 1 at 3:37
fixer1234
18.9k144982
edited Feb 1 at 3:37
fixer1234
18.9k144982
18.9k144982
asked Jan 31 at 18:17
Ivaylo HristovIvaylo Hristov
11
asked Jan 31 at 18:17
Ivaylo HristovIvaylo Hristov
11
asked Jan 31 at 18:17
Ivaylo HristovIvaylo Hristov
11
11
What have you tried so far? What has your research shown you?
– music2myear
Jan 31 at 18:33
Concatenate doesnt work as the link becomes above 255 symbols. If I separate the link in cells and then concatenate them they just dont work as expected. At the end it doesnt show the cell value I am linking to.
– Ivaylo Hristov
Jan 31 at 19:32
Use the EDIT button to add information to the body of the question itself rather than adding this necessary information in comments.
– music2myear
Jan 31 at 19:35
add a comment |
What have you tried so far? What has your research shown you?
– music2myear
Jan 31 at 18:33
Concatenate doesnt work as the link becomes above 255 symbols. If I separate the link in cells and then concatenate them they just dont work as expected. At the end it doesnt show the cell value I am linking to.
– Ivaylo Hristov
Jan 31 at 19:32
Use the EDIT button to add information to the body of the question itself rather than adding this necessary information in comments.
– music2myear
Jan 31 at 19:35
What have you tried so far? What has your research shown you?
– music2myear
Jan 31 at 18:33
What have you tried so far? What has your research shown you?
– music2myear
Jan 31 at 18:33
Concatenate doesnt work as the link becomes above 255 symbols. If I separate the link in cells and then concatenate them they just dont work as expected. At the end it doesnt show the cell value I am linking to.
– Ivaylo Hristov
Jan 31 at 19:32
Concatenate doesnt work as the link becomes above 255 symbols. If I separate the link in cells and then concatenate them they just dont work as expected. At the end it doesnt show the cell value I am linking to.
– Ivaylo Hristov
Jan 31 at 19:32
Use the EDIT button to add information to the body of the question itself rather than adding this necessary information in comments.
– music2myear
Jan 31 at 19:35
Use the EDIT button to add information to the body of the question itself rather than adding this necessary information in comments.
– music2myear
Jan 31 at 19:35
add a comment |
0
active
oldest
votes
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%2f1400693%2fhow-to-add-a-cell-value-in-a-link-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f1400693%2fhow-to-add-a-cell-value-in-a-link-in-excel%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
What have you tried so far? What has your research shown you?
– music2myear
Jan 31 at 18:33
Concatenate doesnt work as the link becomes above 255 symbols. If I separate the link in cells and then concatenate them they just dont work as expected. At the end it doesnt show the cell value I am linking to.
– Ivaylo Hristov
Jan 31 at 19:32
Use the EDIT button to add information to the body of the question itself rather than adding this necessary information in comments.
– music2myear
Jan 31 at 19:35