Cannot break excel link to broken connection
up vote
1
down vote
favorite
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
add a comment |
up vote
1
down vote
favorite
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
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 |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
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
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
862415
862415
asked May 31 '17 at 19:09
Samantha Barrett
612
612
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
up vote
0
down vote
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 |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
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 |
up vote
0
down vote
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 |
up vote
0
down vote
up vote
0
down vote
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
tjejojyj
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.
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.
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