Excel Connections - Edit Links Not Working?
I do not know if this has been asked elsewhere but I looked and googled around for 30 mins and couldn't seem to find much. I have an old file with some drop down boxes for certain cells in an excel spreadsheet. I never really know how it works to be honest, and there are no macros within this sheet. But somehow, there are some links between some cells within the same file.
I recently changed file names and made copies to this master file, but some of the newer copies drop down boxes no longer work, and seems to be wanting to get to the original file. I tried editing this/these link(s) under the ribbon interface using 2016 - Data > Edit Links (under connections), and it brings up a pretty dialogue box, which has this change source button. But after I clicked it and selected the correct file (it's a circular reference, so it is the current file), it simply did nothing and did not update the file name or anything else shown within the dialogue box. And of course, my links are not fixed and the drop down boxes are not working.
I have uploaded the file here with all data stripped out, but the links are still intact there for your review. Any suggestions why I am seeing this? If I want to fix the links, what can I do to achieve that without fixing each of the cells individually? Thanks!
The file is here:
https://drive.google.com/open?id=1Sn27jnQmYvqWHho6Oa0yz7PXVGU4zwPJ
excel
asked Nov 19 '18 at 23:23
IsaIsa
361310
add a comment |
I do not know if this has been asked elsewhere but I looked and googled around for 30 mins and couldn't seem to find much. I have an old file with some drop down boxes for certain cells in an excel spreadsheet. I never really know how it works to be honest, and there are no macros within this sheet. But somehow, there are some links between some cells within the same file.
I recently changed file names and made copies to this master file, but some of the newer copies drop down boxes no longer work, and seems to be wanting to get to the original file. I tried editing this/these link(s) under the ribbon interface using 2016 - Data > Edit Links (under connections), and it brings up a pretty dialogue box, which has this change source button. But after I clicked it and selected the correct file (it's a circular reference, so it is the current file), it simply did nothing and did not update the file name or anything else shown within the dialogue box. And of course, my links are not fixed and the drop down boxes are not working.
I have uploaded the file here with all data stripped out, but the links are still intact there for your review. Any suggestions why I am seeing this? If I want to fix the links, what can I do to achieve that without fixing each of the cells individually? Thanks!
The file is here:
https://drive.google.com/open?id=1Sn27jnQmYvqWHho6Oa0yz7PXVGU4zwPJ
excel
asked Nov 19 '18 at 23:23
IsaIsa
361310
I clarified my question with an edit and noted that I am trying to update the source, not to simply remove the links. thanks!
– Isa
Nov 20 '18 at 15:19
add a comment |
I do not know if this has been asked elsewhere but I looked and googled around for 30 mins and couldn't seem to find much. I have an old file with some drop down boxes for certain cells in an excel spreadsheet. I never really know how it works to be honest, and there are no macros within this sheet. But somehow, there are some links between some cells within the same file.
I recently changed file names and made copies to this master file, but some of the newer copies drop down boxes no longer work, and seems to be wanting to get to the original file. I tried editing this/these link(s) under the ribbon interface using 2016 - Data > Edit Links (under connections), and it brings up a pretty dialogue box, which has this change source button. But after I clicked it and selected the correct file (it's a circular reference, so it is the current file), it simply did nothing and did not update the file name or anything else shown within the dialogue box. And of course, my links are not fixed and the drop down boxes are not working.
I have uploaded the file here with all data stripped out, but the links are still intact there for your review. Any suggestions why I am seeing this? If I want to fix the links, what can I do to achieve that without fixing each of the cells individually? Thanks!
The file is here:
https://drive.google.com/open?id=1Sn27jnQmYvqWHho6Oa0yz7PXVGU4zwPJ
excel
asked Nov 19 '18 at 23:23
IsaIsa
361310
I do not know if this has been asked elsewhere but I looked and googled around for 30 mins and couldn't seem to find much. I have an old file with some drop down boxes for certain cells in an excel spreadsheet. I never really know how it works to be honest, and there are no macros within this sheet. But somehow, there are some links between some cells within the same file.
I recently changed file names and made copies to this master file, but some of the newer copies drop down boxes no longer work, and seems to be wanting to get to the original file. I tried editing this/these link(s) under the ribbon interface using 2016 - Data > Edit Links (under connections), and it brings up a pretty dialogue box, which has this change source button. But after I clicked it and selected the correct file (it's a circular reference, so it is the current file), it simply did nothing and did not update the file name or anything else shown within the dialogue box. And of course, my links are not fixed and the drop down boxes are not working.
I have uploaded the file here with all data stripped out, but the links are still intact there for your review. Any suggestions why I am seeing this? If I want to fix the links, what can I do to achieve that without fixing each of the cells individually? Thanks!
The file is here:
https://drive.google.com/open?id=1Sn27jnQmYvqWHho6Oa0yz7PXVGU4zwPJ
excel
excel
asked Nov 19 '18 at 23:23
IsaIsa
361310
asked Nov 19 '18 at 23:23
IsaIsa
361310
edited Nov 20 '18 at 15:18
Isa
asked Nov 19 '18 at 23:23
IsaIsa
361310
asked Nov 19 '18 at 23:23
IsaIsa
361310
asked Nov 19 '18 at 23:23
IsaIsa
361310
361310
I clarified my question with an edit and noted that I am trying to update the source, not to simply remove the links. thanks!
– Isa
Nov 20 '18 at 15:19
add a comment |
I clarified my question with an edit and noted that I am trying to update the source, not to simply remove the links. thanks!
– Isa
Nov 20 '18 at 15:19
I clarified my question with an edit and noted that I am trying to update the source, not to simply remove the links. thanks!
– Isa
Nov 20 '18 at 15:19
I clarified my question with an edit and noted that I am trying to update the source, not to simply remove the links. thanks!
– Isa
Nov 20 '18 at 15:19
add a comment |
1 Answer
1
active
oldest
votes
These reason you're seeing these links is that there are cells with Data Validation that point to an external file (cell B71, for example).
Remove all Data Validation that is referencing external files, save the file, and re-open. The links should be gone.
answered Nov 20 '18 at 0:22
MiSMiS
793
Is there a way I can actually update the links without going into them individually? Ultimately, I am trying to make them work again instead of removing them. There are quite a number of them around so I wasn't sure what else I can try since the tool thing doesn't seem to cooperate.
– Isa
Nov 20 '18 at 15:16
Select one of the cells with Validation pointing to an external file (B71), change the Source reference, and check "Apply these changes to all other cells with the same settings" at the bottom of the dialog box.
– MiS
Nov 20 '18 at 17:12
Hmm, right clicks doesn't seem to allow me to change source reference, and when I click into data validation, the "Apply these changes to all other cells with the same settings" is greyed out. It works for like B71, but say, B73 doesn't work apparently. And they are not all the same either... I guess I am out of luck other than to manually redo it by hand, which is fine too I guess. It's 25 30 some fields, but I thought there might be a better way...
– Isa
Nov 20 '18 at 21:24
B73 is a merged cell, once you un-merge that cell, the unmerged cells have different validation. Fixing B71 and all others with the same validation should fix the bulk of them. You can find all cells with validation by Go to (F5) -> Special -? Data Validation.
– MiS
Nov 20 '18 at 21:53
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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%2fstackoverflow.com%2fquestions%2f53384082%2fexcel-connections-edit-links-not-working%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
These reason you're seeing these links is that there are cells with Data Validation that point to an external file (cell B71, for example).
Remove all Data Validation that is referencing external files, save the file, and re-open. The links should be gone.
answered Nov 20 '18 at 0:22
MiSMiS
793
Is there a way I can actually update the links without going into them individually? Ultimately, I am trying to make them work again instead of removing them. There are quite a number of them around so I wasn't sure what else I can try since the tool thing doesn't seem to cooperate.
– Isa
Nov 20 '18 at 15:16
Select one of the cells with Validation pointing to an external file (B71), change the Source reference, and check "Apply these changes to all other cells with the same settings" at the bottom of the dialog box.
– MiS
Nov 20 '18 at 17:12
Hmm, right clicks doesn't seem to allow me to change source reference, and when I click into data validation, the "Apply these changes to all other cells with the same settings" is greyed out. It works for like B71, but say, B73 doesn't work apparently. And they are not all the same either... I guess I am out of luck other than to manually redo it by hand, which is fine too I guess. It's 25 30 some fields, but I thought there might be a better way...
– Isa
Nov 20 '18 at 21:24
B73 is a merged cell, once you un-merge that cell, the unmerged cells have different validation. Fixing B71 and all others with the same validation should fix the bulk of them. You can find all cells with validation by Go to (F5) -> Special -? Data Validation.
– MiS
Nov 20 '18 at 21:53
add a comment |
These reason you're seeing these links is that there are cells with Data Validation that point to an external file (cell B71, for example).
Remove all Data Validation that is referencing external files, save the file, and re-open. The links should be gone.
answered Nov 20 '18 at 0:22
MiSMiS
793
Is there a way I can actually update the links without going into them individually? Ultimately, I am trying to make them work again instead of removing them. There are quite a number of them around so I wasn't sure what else I can try since the tool thing doesn't seem to cooperate.
– Isa
Nov 20 '18 at 15:16
Select one of the cells with Validation pointing to an external file (B71), change the Source reference, and check "Apply these changes to all other cells with the same settings" at the bottom of the dialog box.
– MiS
Nov 20 '18 at 17:12
Hmm, right clicks doesn't seem to allow me to change source reference, and when I click into data validation, the "Apply these changes to all other cells with the same settings" is greyed out. It works for like B71, but say, B73 doesn't work apparently. And they are not all the same either... I guess I am out of luck other than to manually redo it by hand, which is fine too I guess. It's 25 30 some fields, but I thought there might be a better way...
– Isa
Nov 20 '18 at 21:24
B73 is a merged cell, once you un-merge that cell, the unmerged cells have different validation. Fixing B71 and all others with the same validation should fix the bulk of them. You can find all cells with validation by Go to (F5) -> Special -? Data Validation.
– MiS
Nov 20 '18 at 21:53
add a comment |
These reason you're seeing these links is that there are cells with Data Validation that point to an external file (cell B71, for example).
Remove all Data Validation that is referencing external files, save the file, and re-open. The links should be gone.
answered Nov 20 '18 at 0:22
MiSMiS
793
These reason you're seeing these links is that there are cells with Data Validation that point to an external file (cell B71, for example).
Remove all Data Validation that is referencing external files, save the file, and re-open. The links should be gone.
answered Nov 20 '18 at 0:22
MiSMiS
793
answered Nov 20 '18 at 0:22
MiSMiS
793
answered Nov 20 '18 at 0:22
MiSMiS
793
answered Nov 20 '18 at 0:22
MiSMiS
793
793
Is there a way I can actually update the links without going into them individually? Ultimately, I am trying to make them work again instead of removing them. There are quite a number of them around so I wasn't sure what else I can try since the tool thing doesn't seem to cooperate.
– Isa
Nov 20 '18 at 15:16
Select one of the cells with Validation pointing to an external file (B71), change the Source reference, and check "Apply these changes to all other cells with the same settings" at the bottom of the dialog box.
– MiS
Nov 20 '18 at 17:12
Hmm, right clicks doesn't seem to allow me to change source reference, and when I click into data validation, the "Apply these changes to all other cells with the same settings" is greyed out. It works for like B71, but say, B73 doesn't work apparently. And they are not all the same either... I guess I am out of luck other than to manually redo it by hand, which is fine too I guess. It's 25 30 some fields, but I thought there might be a better way...
– Isa
Nov 20 '18 at 21:24
B73 is a merged cell, once you un-merge that cell, the unmerged cells have different validation. Fixing B71 and all others with the same validation should fix the bulk of them. You can find all cells with validation by Go to (F5) -> Special -? Data Validation.
– MiS
Nov 20 '18 at 21:53
add a comment |
Is there a way I can actually update the links without going into them individually? Ultimately, I am trying to make them work again instead of removing them. There are quite a number of them around so I wasn't sure what else I can try since the tool thing doesn't seem to cooperate.
– Isa
Nov 20 '18 at 15:16
Select one of the cells with Validation pointing to an external file (B71), change the Source reference, and check "Apply these changes to all other cells with the same settings" at the bottom of the dialog box.
– MiS
Nov 20 '18 at 17:12
Hmm, right clicks doesn't seem to allow me to change source reference, and when I click into data validation, the "Apply these changes to all other cells with the same settings" is greyed out. It works for like B71, but say, B73 doesn't work apparently. And they are not all the same either... I guess I am out of luck other than to manually redo it by hand, which is fine too I guess. It's 25 30 some fields, but I thought there might be a better way...
– Isa
Nov 20 '18 at 21:24
B73 is a merged cell, once you un-merge that cell, the unmerged cells have different validation. Fixing B71 and all others with the same validation should fix the bulk of them. You can find all cells with validation by Go to (F5) -> Special -? Data Validation.
– MiS
Nov 20 '18 at 21:53
Is there a way I can actually update the links without going into them individually? Ultimately, I am trying to make them work again instead of removing them. There are quite a number of them around so I wasn't sure what else I can try since the tool thing doesn't seem to cooperate.
– Isa
Nov 20 '18 at 15:16
Is there a way I can actually update the links without going into them individually? Ultimately, I am trying to make them work again instead of removing them. There are quite a number of them around so I wasn't sure what else I can try since the tool thing doesn't seem to cooperate.
– Isa
Nov 20 '18 at 15:16
Select one of the cells with Validation pointing to an external file (B71), change the Source reference, and check "Apply these changes to all other cells with the same settings" at the bottom of the dialog box.
– MiS
Nov 20 '18 at 17:12
Select one of the cells with Validation pointing to an external file (B71), change the Source reference, and check "Apply these changes to all other cells with the same settings" at the bottom of the dialog box.
– MiS
Nov 20 '18 at 17:12
Hmm, right clicks doesn't seem to allow me to change source reference, and when I click into data validation, the "Apply these changes to all other cells with the same settings" is greyed out. It works for like B71, but say, B73 doesn't work apparently. And they are not all the same either... I guess I am out of luck other than to manually redo it by hand, which is fine too I guess. It's 25 30 some fields, but I thought there might be a better way...
– Isa
Nov 20 '18 at 21:24
Hmm, right clicks doesn't seem to allow me to change source reference, and when I click into data validation, the "Apply these changes to all other cells with the same settings" is greyed out. It works for like B71, but say, B73 doesn't work apparently. And they are not all the same either... I guess I am out of luck other than to manually redo it by hand, which is fine too I guess. It's 25 30 some fields, but I thought there might be a better way...
– Isa
Nov 20 '18 at 21:24
B73 is a merged cell, once you un-merge that cell, the unmerged cells have different validation. Fixing B71 and all others with the same validation should fix the bulk of them. You can find all cells with validation by Go to (F5) -> Special -? Data Validation.
– MiS
Nov 20 '18 at 21:53
B73 is a merged cell, once you un-merge that cell, the unmerged cells have different validation. Fixing B71 and all others with the same validation should fix the bulk of them. You can find all cells with validation by Go to (F5) -> Special -? Data Validation.
– MiS
Nov 20 '18 at 21:53
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53384082%2fexcel-connections-edit-links-not-working%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
I clarified my question with an edit and noted that I am trying to update the source, not to simply remove the links. thanks!
– Isa
Nov 20 '18 at 15:19