Linking data in 2 different Excel workbooks together
I am trying to link data in one workbook to another. So that when data is updated in one workbook, it automatically updates in the other one. I tried using = then selecting the cell in the other workbook and enter. That seemed to work so I did it for all the other rows. Then when I reopened the workbook later on and it asked me to update, which I did. It has now changed the formula and is not working.
As far as I can see, it has linked my data to a previous workbook. I'm not sure if this makes sense. Any information would be greatly appreciated!
microsoft-excel microsoft-excel-2013
asked Feb 5 at 12:24
AllisonAllison
82
add a comment |
I am trying to link data in one workbook to another. So that when data is updated in one workbook, it automatically updates in the other one. I tried using = then selecting the cell in the other workbook and enter. That seemed to work so I did it for all the other rows. Then when I reopened the workbook later on and it asked me to update, which I did. It has now changed the formula and is not working.
As far as I can see, it has linked my data to a previous workbook. I'm not sure if this makes sense. Any information would be greatly appreciated!
microsoft-excel microsoft-excel-2013
asked Feb 5 at 12:24
AllisonAllison
82
add a comment |
I am trying to link data in one workbook to another. So that when data is updated in one workbook, it automatically updates in the other one. I tried using = then selecting the cell in the other workbook and enter. That seemed to work so I did it for all the other rows. Then when I reopened the workbook later on and it asked me to update, which I did. It has now changed the formula and is not working.
As far as I can see, it has linked my data to a previous workbook. I'm not sure if this makes sense. Any information would be greatly appreciated!
microsoft-excel microsoft-excel-2013
asked Feb 5 at 12:24
AllisonAllison
82
I am trying to link data in one workbook to another. So that when data is updated in one workbook, it automatically updates in the other one. I tried using = then selecting the cell in the other workbook and enter. That seemed to work so I did it for all the other rows. Then when I reopened the workbook later on and it asked me to update, which I did. It has now changed the formula and is not working.
As far as I can see, it has linked my data to a previous workbook. I'm not sure if this makes sense. Any information would be greatly appreciated!
microsoft-excel microsoft-excel-2013
microsoft-excel microsoft-excel-2013
asked Feb 5 at 12:24
AllisonAllison
82
asked Feb 5 at 12:24
AllisonAllison
82
asked Feb 5 at 12:24
AllisonAllison
82
asked Feb 5 at 12:24
AllisonAllison
82
asked Feb 5 at 12:24
AllisonAllison
82
82
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I think this link will surely answer your question.
answered Feb 5 at 12:53
Bogdan DoicinBogdan Doicin
609515
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%2f1402231%2flinking-data-in-2-different-excel-workbooks-together%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
I think this link will surely answer your question.
answered Feb 5 at 12:53
Bogdan DoicinBogdan Doicin
609515
add a comment |
I think this link will surely answer your question.
answered Feb 5 at 12:53
Bogdan DoicinBogdan Doicin
609515
add a comment |
I think this link will surely answer your question.
answered Feb 5 at 12:53
Bogdan DoicinBogdan Doicin
609515
I think this link will surely answer your question.
answered Feb 5 at 12:53
Bogdan DoicinBogdan Doicin
609515
answered Feb 5 at 12:53
Bogdan DoicinBogdan Doicin
609515
answered Feb 5 at 12:53
Bogdan DoicinBogdan Doicin
609515
answered Feb 5 at 12:53
Bogdan DoicinBogdan Doicin
609515
609515
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%2f1402231%2flinking-data-in-2-different-excel-workbooks-together%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
