How do I resolve data range failure from Excel?
up vote
0
down vote
favorite
When refreshing a data source in Excel 2013, I get an error about a data range. How do I stop this error from occurring?
I think that the error has something to do with removing connections because it shows an error message stating that refreshing data will fail.
Image of error: 
microsoft-excel-2013 database data-transfer
edited Jun 25 '15 at 3:25
G-Man
5,548102257
asked Jun 24 '15 at 20:57
user3797758
372211
add a comment |
up vote
0
down vote
favorite
When refreshing a data source in Excel 2013, I get an error about a data range. How do I stop this error from occurring?
I think that the error has something to do with removing connections because it shows an error message stating that refreshing data will fail.
Image of error:
microsoft-excel-2013 database data-transfer
edited Jun 25 '15 at 3:25
G-Man
5,548102257
asked Jun 24 '15 at 20:57
user3797758
372211
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
When refreshing a data source in Excel 2013, I get an error about a data range. How do I stop this error from occurring?
I think that the error has something to do with removing connections because it shows an error message stating that refreshing data will fail.
Image of error:
microsoft-excel-2013 database data-transfer
edited Jun 25 '15 at 3:25
G-Man
5,548102257
asked Jun 24 '15 at 20:57
user3797758
372211
When refreshing a data source in Excel 2013, I get an error about a data range. How do I stop this error from occurring?
I think that the error has something to do with removing connections because it shows an error message stating that refreshing data will fail.
Image of error:
microsoft-excel-2013 database data-transfer
microsoft-excel-2013 database data-transfer
edited Jun 25 '15 at 3:25
G-Man
5,548102257
asked Jun 24 '15 at 20:57
user3797758
372211
edited Jun 25 '15 at 3:25
G-Man
5,548102257
asked Jun 24 '15 at 20:57
user3797758
372211
edited Jun 25 '15 at 3:25
G-Man
5,548102257
edited Jun 25 '15 at 3:25
G-Man
5,548102257
edited Jun 25 '15 at 3:25
G-Man
5,548102257
5,548102257
asked Jun 24 '15 at 20:57
user3797758
372211
asked Jun 24 '15 at 20:57
user3797758
372211
asked Jun 24 '15 at 20:57
user3797758
372211
372211
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
up vote
0
down vote
If you go to the DATA tab, there is an icon labelled "Connections". If you click on that, you get a list of connections and you can delete the one called evec_api_map.
answered Jun 24 '15 at 23:17
Julian Knight
12.9k11535
Thats the issue it IS deleted but i get this error message
– user3797758
Jun 25 '15 at 18:47
In that case, you need to look at your named ranges and delete the one that contained the connection. Alternatively, if the workbook is relatively straight-forwards, create a new one and copy over the things you need one at a time saving in between and testing before saving to find which range causes it.
– Julian Knight
Jun 25 '15 at 18:50
I know were the ranges are but i have put new date imports over them, so there gone.
– user3797758
Jun 27 '15 at 1:14
Then something is messed up internally and I think you will have to resort to creating a new workbook as outlined in my previous comment.
– Julian Knight
Jun 28 '15 at 11:45
Yeah thats what I've started doing. Is there a button which removes the dependency from the original workbook? Because if you copy and paste in data from one book to another and you have cells which get data from other sheets it adds [book1.xlsx] to the front of the query. I've Been removing it manually but it sucks :(
– user3797758
Jun 29 '15 at 13:08
add a comment |
up vote
0
down vote
What solved this for me was to delete the XML connection.
In the Developer tab, Source->XML Maps (bottom right)->Delete
answered Feb 13 at 14:41
Quick Maffs
1
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',
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
});
}
});
draft saved
draft discarded
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%2f932224%2fhow-do-i-resolve-data-range-failure-from-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
If you go to the DATA tab, there is an icon labelled "Connections". If you click on that, you get a list of connections and you can delete the one called evec_api_map.
answered Jun 24 '15 at 23:17
Julian Knight
12.9k11535
Thats the issue it IS deleted but i get this error message
– user3797758
Jun 25 '15 at 18:47
In that case, you need to look at your named ranges and delete the one that contained the connection. Alternatively, if the workbook is relatively straight-forwards, create a new one and copy over the things you need one at a time saving in between and testing before saving to find which range causes it.
– Julian Knight
Jun 25 '15 at 18:50
I know were the ranges are but i have put new date imports over them, so there gone.
– user3797758
Jun 27 '15 at 1:14
Then something is messed up internally and I think you will have to resort to creating a new workbook as outlined in my previous comment.
– Julian Knight
Jun 28 '15 at 11:45
Yeah thats what I've started doing. Is there a button which removes the dependency from the original workbook? Because if you copy and paste in data from one book to another and you have cells which get data from other sheets it adds [book1.xlsx] to the front of the query. I've Been removing it manually but it sucks :(
– user3797758
Jun 29 '15 at 13:08
add a comment |
up vote
0
down vote
If you go to the DATA tab, there is an icon labelled "Connections". If you click on that, you get a list of connections and you can delete the one called evec_api_map.
answered Jun 24 '15 at 23:17
Julian Knight
12.9k11535
Thats the issue it IS deleted but i get this error message
– user3797758
Jun 25 '15 at 18:47
In that case, you need to look at your named ranges and delete the one that contained the connection. Alternatively, if the workbook is relatively straight-forwards, create a new one and copy over the things you need one at a time saving in between and testing before saving to find which range causes it.
– Julian Knight
Jun 25 '15 at 18:50
I know were the ranges are but i have put new date imports over them, so there gone.
– user3797758
Jun 27 '15 at 1:14
Then something is messed up internally and I think you will have to resort to creating a new workbook as outlined in my previous comment.
– Julian Knight
Jun 28 '15 at 11:45
Yeah thats what I've started doing. Is there a button which removes the dependency from the original workbook? Because if you copy and paste in data from one book to another and you have cells which get data from other sheets it adds [book1.xlsx] to the front of the query. I've Been removing it manually but it sucks :(
– user3797758
Jun 29 '15 at 13:08
add a comment |
up vote
0
down vote
up vote
0
down vote
If you go to the DATA tab, there is an icon labelled "Connections". If you click on that, you get a list of connections and you can delete the one called evec_api_map.
answered Jun 24 '15 at 23:17
Julian Knight
12.9k11535
If you go to the DATA tab, there is an icon labelled "Connections". If you click on that, you get a list of connections and you can delete the one called evec_api_map.
answered Jun 24 '15 at 23:17
Julian Knight
12.9k11535
answered Jun 24 '15 at 23:17
Julian Knight
12.9k11535
answered Jun 24 '15 at 23:17
Julian Knight
12.9k11535
answered Jun 24 '15 at 23:17
Julian Knight
12.9k11535
12.9k11535
Thats the issue it IS deleted but i get this error message
– user3797758
Jun 25 '15 at 18:47
In that case, you need to look at your named ranges and delete the one that contained the connection. Alternatively, if the workbook is relatively straight-forwards, create a new one and copy over the things you need one at a time saving in between and testing before saving to find which range causes it.
– Julian Knight
Jun 25 '15 at 18:50
I know were the ranges are but i have put new date imports over them, so there gone.
– user3797758
Jun 27 '15 at 1:14
Then something is messed up internally and I think you will have to resort to creating a new workbook as outlined in my previous comment.
– Julian Knight
Jun 28 '15 at 11:45
Yeah thats what I've started doing. Is there a button which removes the dependency from the original workbook? Because if you copy and paste in data from one book to another and you have cells which get data from other sheets it adds [book1.xlsx] to the front of the query. I've Been removing it manually but it sucks :(
– user3797758
Jun 29 '15 at 13:08
add a comment |
Thats the issue it IS deleted but i get this error message
– user3797758
Jun 25 '15 at 18:47
In that case, you need to look at your named ranges and delete the one that contained the connection. Alternatively, if the workbook is relatively straight-forwards, create a new one and copy over the things you need one at a time saving in between and testing before saving to find which range causes it.
– Julian Knight
Jun 25 '15 at 18:50
I know were the ranges are but i have put new date imports over them, so there gone.
– user3797758
Jun 27 '15 at 1:14
Then something is messed up internally and I think you will have to resort to creating a new workbook as outlined in my previous comment.
– Julian Knight
Jun 28 '15 at 11:45
Yeah thats what I've started doing. Is there a button which removes the dependency from the original workbook? Because if you copy and paste in data from one book to another and you have cells which get data from other sheets it adds [book1.xlsx] to the front of the query. I've Been removing it manually but it sucks :(
– user3797758
Jun 29 '15 at 13:08
Thats the issue it IS deleted but i get this error message
– user3797758
Jun 25 '15 at 18:47
Thats the issue it IS deleted but i get this error message
– user3797758
Jun 25 '15 at 18:47
In that case, you need to look at your named ranges and delete the one that contained the connection. Alternatively, if the workbook is relatively straight-forwards, create a new one and copy over the things you need one at a time saving in between and testing before saving to find which range causes it.
– Julian Knight
Jun 25 '15 at 18:50
In that case, you need to look at your named ranges and delete the one that contained the connection. Alternatively, if the workbook is relatively straight-forwards, create a new one and copy over the things you need one at a time saving in between and testing before saving to find which range causes it.
– Julian Knight
Jun 25 '15 at 18:50
I know were the ranges are but i have put new date imports over them, so there gone.
– user3797758
Jun 27 '15 at 1:14
I know were the ranges are but i have put new date imports over them, so there gone.
– user3797758
Jun 27 '15 at 1:14
Then something is messed up internally and I think you will have to resort to creating a new workbook as outlined in my previous comment.
– Julian Knight
Jun 28 '15 at 11:45
Then something is messed up internally and I think you will have to resort to creating a new workbook as outlined in my previous comment.
– Julian Knight
Jun 28 '15 at 11:45
Yeah thats what I've started doing. Is there a button which removes the dependency from the original workbook? Because if you copy and paste in data from one book to another and you have cells which get data from other sheets it adds [book1.xlsx] to the front of the query. I've Been removing it manually but it sucks :(
– user3797758
Jun 29 '15 at 13:08
Yeah thats what I've started doing. Is there a button which removes the dependency from the original workbook? Because if you copy and paste in data from one book to another and you have cells which get data from other sheets it adds [book1.xlsx] to the front of the query. I've Been removing it manually but it sucks :(
– user3797758
Jun 29 '15 at 13:08
add a comment |
up vote
0
down vote
What solved this for me was to delete the XML connection.
In the Developer tab, Source->XML Maps (bottom right)->Delete
answered Feb 13 at 14:41
Quick Maffs
1
add a comment |
up vote
0
down vote
What solved this for me was to delete the XML connection.
In the Developer tab, Source->XML Maps (bottom right)->Delete
answered Feb 13 at 14:41
Quick Maffs
1
add a comment |
up vote
0
down vote
up vote
0
down vote
What solved this for me was to delete the XML connection.
In the Developer tab, Source->XML Maps (bottom right)->Delete
answered Feb 13 at 14:41
Quick Maffs
1
What solved this for me was to delete the XML connection.
In the Developer tab, Source->XML Maps (bottom right)->Delete
answered Feb 13 at 14:41
Quick Maffs
1
answered Feb 13 at 14:41
Quick Maffs
1
answered Feb 13 at 14:41
Quick Maffs
1
answered Feb 13 at 14:41
Quick Maffs
1
1
add a comment |
add a comment |
draft saved
draft discarded
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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.
draft saved
draft discarded
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%2f932224%2fhow-do-i-resolve-data-range-failure-from-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
