Excel, See if Sheet A is referenced elsewhere in Workbook
I have a fairly large workbook. Is there a way to check if a certain sheet is referenced by any other sheets ie via formulas?
For example I have a large dataset in Sheet A, but all the other sheets in my workbook may have some sumifs, vlookups, index match, etc applied referencing sheet A.
I've heard of trace dependents but not sure if it works for entire sheets/ give desired results.
microsoft-excel
edited Dec 7 '18 at 10:17
Mureinik
2,33761625
asked Dec 6 '18 at 21:38
excelguy
448
add a comment |
I have a fairly large workbook. Is there a way to check if a certain sheet is referenced by any other sheets ie via formulas?
For example I have a large dataset in Sheet A, but all the other sheets in my workbook may have some sumifs, vlookups, index match, etc applied referencing sheet A.
I've heard of trace dependents but not sure if it works for entire sheets/ give desired results.
microsoft-excel
edited Dec 7 '18 at 10:17
Mureinik
2,33761625
asked Dec 6 '18 at 21:38
excelguy
448
add a comment |
I have a fairly large workbook. Is there a way to check if a certain sheet is referenced by any other sheets ie via formulas?
For example I have a large dataset in Sheet A, but all the other sheets in my workbook may have some sumifs, vlookups, index match, etc applied referencing sheet A.
I've heard of trace dependents but not sure if it works for entire sheets/ give desired results.
microsoft-excel
edited Dec 7 '18 at 10:17
Mureinik
2,33761625
asked Dec 6 '18 at 21:38
excelguy
448
I have a fairly large workbook. Is there a way to check if a certain sheet is referenced by any other sheets ie via formulas?
For example I have a large dataset in Sheet A, but all the other sheets in my workbook may have some sumifs, vlookups, index match, etc applied referencing sheet A.
I've heard of trace dependents but not sure if it works for entire sheets/ give desired results.
microsoft-excel
microsoft-excel
edited Dec 7 '18 at 10:17
Mureinik
2,33761625
asked Dec 6 '18 at 21:38
excelguy
448
edited Dec 7 '18 at 10:17
Mureinik
2,33761625
asked Dec 6 '18 at 21:38
excelguy
448
edited Dec 7 '18 at 10:17
Mureinik
2,33761625
edited Dec 7 '18 at 10:17
Mureinik
2,33761625
edited Dec 7 '18 at 10:17
Mureinik
2,33761625
2,33761625
asked Dec 6 '18 at 21:38
excelguy
448
asked Dec 6 '18 at 21:38
excelguy
448
asked Dec 6 '18 at 21:38
excelguy
448
448
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Use the Find function:
- CTRL+F
- Click
Options >>
- Within: Workbook
- Look in: Formulas
- Find What:
Type your sheetname here
You can use "Find Next" to look at them one at a time or press "Find All" to get a list of all places at once.
answered Dec 6 '18 at 22:04
HackSlash
1,8851620
thanks for this.
– excelguy
Dec 6 '18 at 22:11
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%2f1381469%2fexcel-see-if-sheet-a-is-referenced-elsewhere-in-workbook%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
Use the Find function:
- CTRL+F
- Click
Options >>
- Within: Workbook
- Look in: Formulas
- Find What:
Type your sheetname here
You can use "Find Next" to look at them one at a time or press "Find All" to get a list of all places at once.
answered Dec 6 '18 at 22:04
HackSlash
1,8851620
thanks for this.
– excelguy
Dec 6 '18 at 22:11
add a comment |
Use the Find function:
- CTRL+F
- Click
Options >>
- Within: Workbook
- Look in: Formulas
- Find What:
Type your sheetname here
You can use "Find Next" to look at them one at a time or press "Find All" to get a list of all places at once.
answered Dec 6 '18 at 22:04
HackSlash
1,8851620
thanks for this.
– excelguy
Dec 6 '18 at 22:11
add a comment |
Use the Find function:
- CTRL+F
- Click
Options >>
- Within: Workbook
- Look in: Formulas
- Find What:
Type your sheetname here
You can use "Find Next" to look at them one at a time or press "Find All" to get a list of all places at once.
answered Dec 6 '18 at 22:04
HackSlash
1,8851620
Use the Find function:
- CTRL+F
- Click
Options >>
- Within: Workbook
- Look in: Formulas
- Find What:
Type your sheetname here
You can use "Find Next" to look at them one at a time or press "Find All" to get a list of all places at once.
answered Dec 6 '18 at 22:04
HackSlash
1,8851620
answered Dec 6 '18 at 22:04
HackSlash
1,8851620
answered Dec 6 '18 at 22:04
HackSlash
1,8851620
answered Dec 6 '18 at 22:04
HackSlash
1,8851620
1,8851620
thanks for this.
– excelguy
Dec 6 '18 at 22:11
add a comment |
thanks for this.
– excelguy
Dec 6 '18 at 22:11
thanks for this.
– excelguy
Dec 6 '18 at 22:11
thanks for this.
– excelguy
Dec 6 '18 at 22:11
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%2f1381469%2fexcel-see-if-sheet-a-is-referenced-elsewhere-in-workbook%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
