Cannot break excel link to broken connection Unicorn Meta Zoo #1: Why another podcast? ...
Intern got a job offer for same salary than a long term team member
Why does Arg'[1. + I] return -0.5?
Is there any pythonic way to find average of specific tuple elements in array?
Scheduling based problem
"My boss was furious with me and I have been fired" vs. "My boss was furious with me and I was fired"
Long vowel quality before R
Crossed out red box fitting tightly around image
My bank got bought out, am I now going to have to start filing tax returns in a different state?
Israeli soda type drink
Co-worker works way more than he should
How much of a wave function must reside inside event horizon for it to be consumed by the black hole?
Protagonist's race is hidden - should I reveal it?
Is it acceptable to use working hours to read general interest books?
What is the term for a person whose job is to place products on shelves in stores?
What is it called when you ride around on your front wheel?
How to have a sharp product image?
All ASCII characters with a given bit count
Retract an already submitted recommendation letter (written for an undergrad student)
Is Diceware more secure than a long passphrase?
Is there really no use for MD5 anymore?
Is accepting an invalid credit card number a security issue?
How exactly does Hawking radiation decrease the mass of black holes?
Why must Chinese maps be obfuscated?
std::unique_ptr of base class holding reference of derived class does not show warning in gcc compiler while naked pointer shows it. Why?
Cannot break excel link to broken connection
Unicorn Meta Zoo #1: Why another podcast?
Announcing the arrival of Valued Associate #679: Cesar ManaraHow to find broken links in Excel that can't be broken with 'Break Links'?Why am I unable to use a named range beginning with “Corona” in Excel charts?Why is sharepoint (onedrive) giving the error “Links to external workbooks are not supported and have been disabled” when there are no external links?Excel: what makes .xlsx files use less space than .xls files?Two-way data update with Excel PowerPivot tables (Office 2013)How can I Implement Dynamic Dependent Data Validation List in Excelerror when save .xlsm --> .xltmConnecting two different data sources pivots with single slicerIn excel, why can I create a relationship between Table 1 and Table 2, but I can't create one going in the opposite direction?How to retain internal connections (existing worksheet) in excelHow to remove an obsolete/invalid table reference
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I have a file and I cannot seem to find where the connection is. I have look in the following places:
- Data>>Connections
- Conditional formatting
- Searches for "[" and ".xl"
- Data Validation, but there is none
- All pivot tables data sources have been checked
- Named ranges
- File >> Info >> Related documents
Any other suggestions that I can use to find where this link is?
Photo of error message:
microsoft-excel connection
edited May 31 '17 at 22:45
LevenTech
882415
asked May 31 '17 at 19:09
Samantha BarrettSamantha Barrett
6112
bumped to the homepage by Community♦ 21 hours ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I have a file and I cannot seem to find where the connection is. I have look in the following places:
- Data>>Connections
- Conditional formatting
- Searches for "[" and ".xl"
- Data Validation, but there is none
- All pivot tables data sources have been checked
- Named ranges
- File >> Info >> Related documents
Any other suggestions that I can use to find where this link is?
Photo of error message:
microsoft-excel connection
edited May 31 '17 at 22:45
LevenTech
882415
asked May 31 '17 at 19:09
Samantha BarrettSamantha Barrett
6112
bumped to the homepage by Community♦ 21 hours ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Maybe its contained in a macro? Go to the view, on the bar, and select macros to see if there are any.
– mt025
May 31 '17 at 19:53
@LevenTech: If an image is already on i.stack.imgur.com, you don't need to download and re-upload it — just edit the markdown.
– G-Man
Jun 3 '17 at 6:30
add a comment |
I have a file and I cannot seem to find where the connection is. I have look in the following places:
- Data>>Connections
- Conditional formatting
- Searches for "[" and ".xl"
- Data Validation, but there is none
- All pivot tables data sources have been checked
- Named ranges
- File >> Info >> Related documents
Any other suggestions that I can use to find where this link is?
Photo of error message:
microsoft-excel connection
edited May 31 '17 at 22:45
LevenTech
882415
asked May 31 '17 at 19:09
Samantha BarrettSamantha Barrett
6112
I have a file and I cannot seem to find where the connection is. I have look in the following places:
- Data>>Connections
- Conditional formatting
- Searches for "[" and ".xl"
- Data Validation, but there is none
- All pivot tables data sources have been checked
- Named ranges
- File >> Info >> Related documents
Any other suggestions that I can use to find where this link is?
Photo of error message:
microsoft-excel connection
microsoft-excel connection
edited May 31 '17 at 22:45
LevenTech
882415
asked May 31 '17 at 19:09
Samantha BarrettSamantha Barrett
6112
edited May 31 '17 at 22:45
LevenTech
882415
asked May 31 '17 at 19:09
Samantha BarrettSamantha Barrett
6112
edited May 31 '17 at 22:45
LevenTech
882415
edited May 31 '17 at 22:45
LevenTech
882415
edited May 31 '17 at 22:45
LevenTech
882415
882415
asked May 31 '17 at 19:09
Samantha BarrettSamantha Barrett
6112
asked May 31 '17 at 19:09
Samantha BarrettSamantha Barrett
6112
asked May 31 '17 at 19:09
Samantha BarrettSamantha Barrett
6112
6112
bumped to the homepage by Community♦ 21 hours ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 21 hours ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Maybe its contained in a macro? Go to the view, on the bar, and select macros to see if there are any.
– mt025
May 31 '17 at 19:53
@LevenTech: If an image is already on i.stack.imgur.com, you don't need to download and re-upload it — just edit the markdown.
– G-Man
Jun 3 '17 at 6:30
add a comment |
Maybe its contained in a macro? Go to the view, on the bar, and select macros to see if there are any.
– mt025
May 31 '17 at 19:53
@LevenTech: If an image is already on i.stack.imgur.com, you don't need to download and re-upload it — just edit the markdown.
– G-Man
Jun 3 '17 at 6:30
Maybe its contained in a macro? Go to the view, on the bar, and select macros to see if there are any.
– mt025
May 31 '17 at 19:53
Maybe its contained in a macro? Go to the view, on the bar, and select macros to see if there are any.
– mt025
May 31 '17 at 19:53
@LevenTech: If an image is already on i.stack.imgur.com, you don't need to download and re-upload it — just edit the markdown.
– G-Man
Jun 3 '17 at 6:30
@LevenTech: If an image is already on i.stack.imgur.com, you don't need to download and re-upload it — just edit the markdown.
– G-Man
Jun 3 '17 at 6:30
add a comment |
1 Answer
1
active
oldest
votes
Answer from other thread, (posted a community wiki).
Here's a solution that has been very reliable for me:
- Change the file extension of your .xlsx file to .zip
- Unzip this zip in a new folder
- List item Using Explorer, in that folder, search for the name in the file CONTENTS.
Note: Sometimes the name is written in URL format, e.g., %20 instead of spaces, so you might consider using a simplified string that is found only in the problematic file. I used last word of the filename + .xlsx.
It will probably return sheetN.xml as a result. This is the file corresponding to your problematic sheet, where N is the number of the problematic sheet in the order they are displayed. Open it in a text editor such as Notepad.
Find the search string and look at the code around it; it should point you to some cell references that you can lookup in the problematic sheet.
Note: As pointed out before, it could also be in Conditional Formatting or Data Validation.
Source: /719931/how-to-find-broken-links-in-excel-that-cant-be-broken-with-break-links/
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%2f1214777%2fcannot-break-excel-link-to-broken-connection%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
Answer from other thread, (posted a community wiki).
Here's a solution that has been very reliable for me:
- Change the file extension of your .xlsx file to .zip
- Unzip this zip in a new folder
- List item Using Explorer, in that folder, search for the name in the file CONTENTS.
Note: Sometimes the name is written in URL format, e.g., %20 instead of spaces, so you might consider using a simplified string that is found only in the problematic file. I used last word of the filename + .xlsx.
It will probably return sheetN.xml as a result. This is the file corresponding to your problematic sheet, where N is the number of the problematic sheet in the order they are displayed. Open it in a text editor such as Notepad.
Find the search string and look at the code around it; it should point you to some cell references that you can lookup in the problematic sheet.
Note: As pointed out before, it could also be in Conditional Formatting or Data Validation.
Source: /719931/how-to-find-broken-links-in-excel-that-cant-be-broken-with-break-links/
add a comment |
Answer from other thread, (posted a community wiki).
Here's a solution that has been very reliable for me:
- Change the file extension of your .xlsx file to .zip
- Unzip this zip in a new folder
- List item Using Explorer, in that folder, search for the name in the file CONTENTS.
Note: Sometimes the name is written in URL format, e.g., %20 instead of spaces, so you might consider using a simplified string that is found only in the problematic file. I used last word of the filename + .xlsx.
It will probably return sheetN.xml as a result. This is the file corresponding to your problematic sheet, where N is the number of the problematic sheet in the order they are displayed. Open it in a text editor such as Notepad.
Find the search string and look at the code around it; it should point you to some cell references that you can lookup in the problematic sheet.
Note: As pointed out before, it could also be in Conditional Formatting or Data Validation.
Source: /719931/how-to-find-broken-links-in-excel-that-cant-be-broken-with-break-links/
add a comment |
Answer from other thread, (posted a community wiki).
Here's a solution that has been very reliable for me:
- Change the file extension of your .xlsx file to .zip
- Unzip this zip in a new folder
- List item Using Explorer, in that folder, search for the name in the file CONTENTS.
Note: Sometimes the name is written in URL format, e.g., %20 instead of spaces, so you might consider using a simplified string that is found only in the problematic file. I used last word of the filename + .xlsx.
It will probably return sheetN.xml as a result. This is the file corresponding to your problematic sheet, where N is the number of the problematic sheet in the order they are displayed. Open it in a text editor such as Notepad.
Find the search string and look at the code around it; it should point you to some cell references that you can lookup in the problematic sheet.
Note: As pointed out before, it could also be in Conditional Formatting or Data Validation.
Source: /719931/how-to-find-broken-links-in-excel-that-cant-be-broken-with-break-links/
Answer from other thread, (posted a community wiki).
Here's a solution that has been very reliable for me:
- Change the file extension of your .xlsx file to .zip
- Unzip this zip in a new folder
- List item Using Explorer, in that folder, search for the name in the file CONTENTS.
Note: Sometimes the name is written in URL format, e.g., %20 instead of spaces, so you might consider using a simplified string that is found only in the problematic file. I used last word of the filename + .xlsx.
It will probably return sheetN.xml as a result. This is the file corresponding to your problematic sheet, where N is the number of the problematic sheet in the order they are displayed. Open it in a text editor such as Notepad.
Find the search string and look at the code around it; it should point you to some cell references that you can lookup in the problematic sheet.
Note: As pointed out before, it could also be in Conditional Formatting or Data Validation.
Source: /719931/how-to-find-broken-links-in-excel-that-cant-be-broken-with-break-links/
answered Jul 11 '17 at 7:54
community wiki
Tim Joy T-Square Consulting
add a comment |
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%2f1214777%2fcannot-break-excel-link-to-broken-connection%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
Maybe its contained in a macro? Go to the view, on the bar, and select macros to see if there are any.
– mt025
May 31 '17 at 19:53
@LevenTech: If an image is already on i.stack.imgur.com, you don't need to download and re-upload it — just edit the markdown.
– G-Man
Jun 3 '17 at 6:30