Refering to a Cell in a Different Workbook

up vote
1
down vote

favorite

I work between different spreadsheets, and I like to have one main workbook that links to certain cells in other workbooks.

For example, I will do a statement of business activities workbook that has all the business expenses listed, and then I will have individual workbooks for each expense account.

In the old excel, I would just put

=(and then go to the workbook that i wanted, and then select the cell i wanted and then hit enter)

and it would put the amount from that specific cell in my statement of business activities.

When I try to do that in excel 2010, I put the equals sign in the cell, and then go to the other workbook and find the cell I want, and when I hit enter, it just moves down a line and nothing happens in the other workbook.

How can I get this to work again, what do i need to do??

edited Jun 26 '12 at 14:22

SeanC

3,27411425

asked Jun 20 '12 at 20:47

Anna

612

add a comment |

up vote
1
down vote

favorite

I work between different spreadsheets, and I like to have one main workbook that links to certain cells in other workbooks.

For example, I will do a statement of business activities workbook that has all the business expenses listed, and then I will have individual workbooks for each expense account.

In the old excel, I would just put

=(and then go to the workbook that i wanted, and then select the cell i wanted and then hit enter)

and it would put the amount from that specific cell in my statement of business activities.

How can I get this to work again, what do i need to do??

edited Jun 26 '12 at 14:22

SeanC

3,27411425

asked Jun 20 '12 at 20:47

Anna

612

add a comment |

up vote
1
down vote

favorite

I work between different spreadsheets, and I like to have one main workbook that links to certain cells in other workbooks.

For example, I will do a statement of business activities workbook that has all the business expenses listed, and then I will have individual workbooks for each expense account.

In the old excel, I would just put

=(and then go to the workbook that i wanted, and then select the cell i wanted and then hit enter)

and it would put the amount from that specific cell in my statement of business activities.

How can I get this to work again, what do i need to do??

edited Jun 26 '12 at 14:22

SeanC

3,27411425

asked Jun 20 '12 at 20:47

Anna

612

I work between different spreadsheets, and I like to have one main workbook that links to certain cells in other workbooks.

For example, I will do a statement of business activities workbook that has all the business expenses listed, and then I will have individual workbooks for each expense account.

In the old excel, I would just put

=(and then go to the workbook that i wanted, and then select the cell i wanted and then hit enter)

and it would put the amount from that specific cell in my statement of business activities.

How can I get this to work again, what do i need to do??

microsoft-excel worksheet-function

edited Jun 26 '12 at 14:22

SeanC

3,27411425

asked Jun 20 '12 at 20:47

Anna

612

edited Jun 26 '12 at 14:22

SeanC

3,27411425

asked Jun 20 '12 at 20:47

Anna

612

edited Jun 26 '12 at 14:22

SeanC

3,27411425

edited Jun 26 '12 at 14:22

SeanC

3,27411425

edited Jun 26 '12 at 14:22

SeanC

3,27411425

asked Jun 20 '12 at 20:47

Anna

612

asked Jun 20 '12 at 20:47

Anna

612

asked Jun 20 '12 at 20:47

Anna

612

add a comment |

3 Answers
3

active

oldest

votes

up vote
3
down vote

Check if you have two instances of Excel running with a workbook open in each instance. If so, they won't be able to "communicate" with each other and you won't be able to create external links between them.

To fix this, you may either:

Close the other workbook. With only one instance remaining, use CTRL+O or File > Open to re-open the workbook that you've just closed.

or

Close both workbooks first, open one and then when Excel is up, use CTRL+O or File > Open to launch the other one.

edited Jun 20 '12 at 21:43

answered Jun 20 '12 at 20:55

Ellesa

8,50922746

How do I open both in a single instance?
– Anna
Jun 20 '12 at 21:13

@Anna Close the other workbook. With only one instance remaining, use CTRL+O or File>Open to re-open the workbook you just closed.
– Ellesa
Jun 20 '12 at 21:25

@Anna You could also close both workbooks first, open one and then when Excel is up, use CTRL+O or File>Open to launch the other one.
– Ellesa
Jun 20 '12 at 21:27

You're welcome. Feel free to accept this answer by clicking the 'check' mark to the left of this panel. (For more info: meta.stackexchange.com/a/5235)
– Ellesa
Jun 20 '12 at 21:40

NB: It seems that this is no longer an issue in Excel 2013; i.e. this allows a single instance of Excel with multiple open workbooks to behave in the same way as multiple instances; that is you can work with multiple monitors and have workbooks communicate with one another as expected without having to open the workbooks in a specific way.
– JohnLBevan
Mar 7 '16 at 12:32

add a comment |

up vote
0
down vote

Issue still persists in 2016-O365. If an instance of Excel is first launched via hyperlink to a CSV file, and a second is launched via File Explorer, the sheets won't talk to each other. This is true even if you first save the CSV to XLSX format on the same logical drive. To fix this, save & close the hyperlink-launched Excel instance and reopen the file via File Explorer.

answered Oct 3 at 19:32

Steve

add a comment |

up vote
0
down vote

I just found this and as a matter of fact; if you know all the workbooks you are using are trustworthy. You can go to the trustcenter and change the settings.

file> options> trust center> trust center settings> trusted documents> **click on disable trusted documents> ok

This allows the workbooks to communicate without any issue.

**********discard this*******************

edited Nov 20 at 18:44

answered Nov 20 at 18:36

mimi

New contributor

If you are trying to retract this answer, because you have discovered that it is wrong, look below the answer, toward the left, for a ‘‘Delete’’ link, and click it. It that doesn’t work, please say something more explicit, like “This answer is wrong; please ignore it.”
– Scott
Nov 20 at 19:08

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');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f439472%2frefering-to-a-cell-in-a-different-workbook%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

3 Answers
3

active

oldest

votes

3 Answers
3

active

oldest

votes

up vote
3
down vote

To fix this, you may either:

Close the other workbook. With only one instance remaining, use CTRL+O or File > Open to re-open the workbook that you've just closed.

or

Close both workbooks first, open one and then when Excel is up, use CTRL+O or File > Open to launch the other one.

edited Jun 20 '12 at 21:43

answered Jun 20 '12 at 20:55

Ellesa

8,50922746

How do I open both in a single instance?
– Anna
Jun 20 '12 at 21:13

@Anna Close the other workbook. With only one instance remaining, use CTRL+O or File>Open to re-open the workbook you just closed.
– Ellesa
Jun 20 '12 at 21:25

@Anna You could also close both workbooks first, open one and then when Excel is up, use CTRL+O or File>Open to launch the other one.
– Ellesa
Jun 20 '12 at 21:27

You're welcome. Feel free to accept this answer by clicking the 'check' mark to the left of this panel. (For more info: meta.stackexchange.com/a/5235)
– Ellesa
Jun 20 '12 at 21:40

NB: It seems that this is no longer an issue in Excel 2013; i.e. this allows a single instance of Excel with multiple open workbooks to behave in the same way as multiple instances; that is you can work with multiple monitors and have workbooks communicate with one another as expected without having to open the workbooks in a specific way.
– JohnLBevan
Mar 7 '16 at 12:32

add a comment |

up vote
3
down vote

To fix this, you may either:

Close the other workbook. With only one instance remaining, use CTRL+O or File > Open to re-open the workbook that you've just closed.

or

Close both workbooks first, open one and then when Excel is up, use CTRL+O or File > Open to launch the other one.

edited Jun 20 '12 at 21:43

answered Jun 20 '12 at 20:55

Ellesa

8,50922746

How do I open both in a single instance?
– Anna
Jun 20 '12 at 21:13

@Anna Close the other workbook. With only one instance remaining, use CTRL+O or File>Open to re-open the workbook you just closed.
– Ellesa
Jun 20 '12 at 21:25

@Anna You could also close both workbooks first, open one and then when Excel is up, use CTRL+O or File>Open to launch the other one.
– Ellesa
Jun 20 '12 at 21:27

You're welcome. Feel free to accept this answer by clicking the 'check' mark to the left of this panel. (For more info: meta.stackexchange.com/a/5235)
– Ellesa
Jun 20 '12 at 21:40

NB: It seems that this is no longer an issue in Excel 2013; i.e. this allows a single instance of Excel with multiple open workbooks to behave in the same way as multiple instances; that is you can work with multiple monitors and have workbooks communicate with one another as expected without having to open the workbooks in a specific way.
– JohnLBevan
Mar 7 '16 at 12:32

add a comment |

up vote
3
down vote

To fix this, you may either:

Close the other workbook. With only one instance remaining, use CTRL+O or File > Open to re-open the workbook that you've just closed.

or

Close both workbooks first, open one and then when Excel is up, use CTRL+O or File > Open to launch the other one.

edited Jun 20 '12 at 21:43

answered Jun 20 '12 at 20:55

Ellesa

8,50922746

To fix this, you may either:

Close the other workbook. With only one instance remaining, use CTRL+O or File > Open to re-open the workbook that you've just closed.

or

Close both workbooks first, open one and then when Excel is up, use CTRL+O or File > Open to launch the other one.

edited Jun 20 '12 at 21:43

answered Jun 20 '12 at 20:55

Ellesa

8,50922746

edited Jun 20 '12 at 21:43

answered Jun 20 '12 at 20:55

Ellesa

8,50922746

answered Jun 20 '12 at 20:55

Ellesa

8,50922746

answered Jun 20 '12 at 20:55

Ellesa

8,50922746

How do I open both in a single instance?
– Anna
Jun 20 '12 at 21:13

@Anna Close the other workbook. With only one instance remaining, use CTRL+O or File>Open to re-open the workbook you just closed.
– Ellesa
Jun 20 '12 at 21:25

@Anna You could also close both workbooks first, open one and then when Excel is up, use CTRL+O or File>Open to launch the other one.
– Ellesa
Jun 20 '12 at 21:27

You're welcome. Feel free to accept this answer by clicking the 'check' mark to the left of this panel. (For more info: meta.stackexchange.com/a/5235)
– Ellesa
Jun 20 '12 at 21:40

NB: It seems that this is no longer an issue in Excel 2013; i.e. this allows a single instance of Excel with multiple open workbooks to behave in the same way as multiple instances; that is you can work with multiple monitors and have workbooks communicate with one another as expected without having to open the workbooks in a specific way.
– JohnLBevan
Mar 7 '16 at 12:32

add a comment |

How do I open both in a single instance?
– Anna
Jun 20 '12 at 21:13

@Anna Close the other workbook. With only one instance remaining, use CTRL+O or File>Open to re-open the workbook you just closed.
– Ellesa
Jun 20 '12 at 21:25

@Anna You could also close both workbooks first, open one and then when Excel is up, use CTRL+O or File>Open to launch the other one.
– Ellesa
Jun 20 '12 at 21:27

You're welcome. Feel free to accept this answer by clicking the 'check' mark to the left of this panel. (For more info: meta.stackexchange.com/a/5235)
– Ellesa
Jun 20 '12 at 21:40

NB: It seems that this is no longer an issue in Excel 2013; i.e. this allows a single instance of Excel with multiple open workbooks to behave in the same way as multiple instances; that is you can work with multiple monitors and have workbooks communicate with one another as expected without having to open the workbooks in a specific way.
– JohnLBevan
Mar 7 '16 at 12:32

How do I open both in a single instance?
– Anna
Jun 20 '12 at 21:13

@Anna Close the other workbook. With only one instance remaining, use CTRL+O or File>Open to re-open the workbook you just closed.
– Ellesa
Jun 20 '12 at 21:25

@Anna You could also close both workbooks first, open one and then when Excel is up, use CTRL+O or File>Open to launch the other one.
– Ellesa
Jun 20 '12 at 21:27

You're welcome. Feel free to accept this answer by clicking the 'check' mark to the left of this panel. (For more info: meta.stackexchange.com/a/5235)
– Ellesa
Jun 20 '12 at 21:40

NB: It seems that this is no longer an issue in Excel 2013; i.e. this allows a single instance of Excel with multiple open workbooks to behave in the same way as multiple instances; that is you can work with multiple monitors and have workbooks communicate with one another as expected without having to open the workbooks in a specific way.
– JohnLBevan
Mar 7 '16 at 12:32

add a comment |

up vote
0
down vote

answered Oct 3 at 19:32

Steve

add a comment |

up vote
0
down vote

answered Oct 3 at 19:32

Steve

add a comment |

up vote
0
down vote

answered Oct 3 at 19:32

Steve

answered Oct 3 at 19:32

Steve

answered Oct 3 at 19:32

Steve

answered Oct 3 at 19:32

Steve

answered Oct 3 at 19:32

Steve

add a comment |

up vote
0
down vote

I just found this and as a matter of fact; if you know all the workbooks you are using are trustworthy. You can go to the trustcenter and change the settings.

file> options> trust center> trust center settings> trusted documents> **click on disable trusted documents> ok

This allows the workbooks to communicate without any issue.

**********discard this*******************

edited Nov 20 at 18:44

answered Nov 20 at 18:36

mimi

New contributor

If you are trying to retract this answer, because you have discovered that it is wrong, look below the answer, toward the left, for a ‘‘Delete’’ link, and click it. It that doesn’t work, please say something more explicit, like “This answer is wrong; please ignore it.”
– Scott
Nov 20 at 19:08

add a comment |

up vote
0
down vote

I just found this and as a matter of fact; if you know all the workbooks you are using are trustworthy. You can go to the trustcenter and change the settings.

file> options> trust center> trust center settings> trusted documents> **click on disable trusted documents> ok

This allows the workbooks to communicate without any issue.

**********discard this*******************

edited Nov 20 at 18:44

answered Nov 20 at 18:36

mimi

New contributor

If you are trying to retract this answer, because you have discovered that it is wrong, look below the answer, toward the left, for a ‘‘Delete’’ link, and click it. It that doesn’t work, please say something more explicit, like “This answer is wrong; please ignore it.”
– Scott
Nov 20 at 19:08

add a comment |

up vote
0
down vote

I just found this and as a matter of fact; if you know all the workbooks you are using are trustworthy. You can go to the trustcenter and change the settings.

file> options> trust center> trust center settings> trusted documents> **click on disable trusted documents> ok

This allows the workbooks to communicate without any issue.

**********discard this*******************

edited Nov 20 at 18:44

answered Nov 20 at 18:36

mimi

New contributor

I just found this and as a matter of fact; if you know all the workbooks you are using are trustworthy. You can go to the trustcenter and change the settings.

file> options> trust center> trust center settings> trusted documents> **click on disable trusted documents> ok

This allows the workbooks to communicate without any issue.

**********discard this*******************

edited Nov 20 at 18:44

answered Nov 20 at 18:36

mimi

New contributor

edited Nov 20 at 18:44

answered Nov 20 at 18:36

mimi

New contributor

answered Nov 20 at 18:36

mimi

answered Nov 20 at 18:36

mimi

New contributor

mimi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

If you are trying to retract this answer, because you have discovered that it is wrong, look below the answer, toward the left, for a ‘‘Delete’’ link, and click it. It that doesn’t work, please say something more explicit, like “This answer is wrong; please ignore it.”
– Scott
Nov 20 at 19:08

add a comment |

If you are trying to retract this answer, because you have discovered that it is wrong, look below the answer, toward the left, for a ‘‘Delete’’ link, and click it. It that doesn’t work, please say something more explicit, like “This answer is wrong; please ignore it.”
– Scott
Nov 20 at 19:08

If you are trying to retract this answer, because you have discovered that it is wrong, look below the answer, toward the left, for a ‘‘Delete’’ link, and click it. It that doesn’t work, please say something more explicit, like “This answer is wrong; please ignore it.”
– Scott
Nov 20 at 19:08

add a comment |

draft saved

draft discarded

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Bdtyktl