Regular Crashing in Excel - Possible cause referencing entire column
I've been using Excel from Office 365 for the last 2 years on Windows 10 and get crashes almost daily. I need to have several workbooks open at any one time but don't see why this should be an issue as it wasn't when I was previously using an older version of Excel.
I've just come across a link on the official MS Office website here and was shocked to see the following;
The following things can cause performance or crashing issues:
Formulas referencing entire columns.
I'm referencing entire columns all the time using several functions such as sumifs, average, etc. eg: =average(A:A) and surely I can't be the only one.
Is this likely to be the cause and does anyone know of a workaround?
microsoft-excel
asked Dec 7 '18 at 7:15
TomC
995
add a comment |
I've been using Excel from Office 365 for the last 2 years on Windows 10 and get crashes almost daily. I need to have several workbooks open at any one time but don't see why this should be an issue as it wasn't when I was previously using an older version of Excel.
I've just come across a link on the official MS Office website here and was shocked to see the following;
The following things can cause performance or crashing issues:
Formulas referencing entire columns.
I'm referencing entire columns all the time using several functions such as sumifs, average, etc. eg: =average(A:A) and surely I can't be the only one.
Is this likely to be the cause and does anyone know of a workaround?
microsoft-excel
asked Dec 7 '18 at 7:15
TomC
995
add a comment |
I've been using Excel from Office 365 for the last 2 years on Windows 10 and get crashes almost daily. I need to have several workbooks open at any one time but don't see why this should be an issue as it wasn't when I was previously using an older version of Excel.
I've just come across a link on the official MS Office website here and was shocked to see the following;
The following things can cause performance or crashing issues:
Formulas referencing entire columns.
I'm referencing entire columns all the time using several functions such as sumifs, average, etc. eg: =average(A:A) and surely I can't be the only one.
Is this likely to be the cause and does anyone know of a workaround?
microsoft-excel
asked Dec 7 '18 at 7:15
TomC
995
I've been using Excel from Office 365 for the last 2 years on Windows 10 and get crashes almost daily. I need to have several workbooks open at any one time but don't see why this should be an issue as it wasn't when I was previously using an older version of Excel.
I've just come across a link on the official MS Office website here and was shocked to see the following;
The following things can cause performance or crashing issues:
Formulas referencing entire columns.
I'm referencing entire columns all the time using several functions such as sumifs, average, etc. eg: =average(A:A) and surely I can't be the only one.
Is this likely to be the cause and does anyone know of a workaround?
microsoft-excel
microsoft-excel
asked Dec 7 '18 at 7:15
TomC
995
asked Dec 7 '18 at 7:15
TomC
995
asked Dec 7 '18 at 7:15
TomC
995
asked Dec 7 '18 at 7:15
TomC
995
asked Dec 7 '18 at 7:15
TomC
995
995
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
The usual way to reference data in a column is to specify the first and last cell, like =average(A2:A99).
That has some disadvantages, like adding at the bottom is not automatically included in the range, but that's just a matter of getting used to insert before the last line instead.
Using A:A instead is a short-cut that kind-of-works, but if you use the full version, you can avoid your issues.
answered Dec 7 '18 at 22:15
Aganju
8,42231335
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%2f1381562%2fregular-crashing-in-excel-possible-cause-referencing-entire-column%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
The usual way to reference data in a column is to specify the first and last cell, like =average(A2:A99).
That has some disadvantages, like adding at the bottom is not automatically included in the range, but that's just a matter of getting used to insert before the last line instead.
Using A:A instead is a short-cut that kind-of-works, but if you use the full version, you can avoid your issues.
answered Dec 7 '18 at 22:15
Aganju
8,42231335
add a comment |
The usual way to reference data in a column is to specify the first and last cell, like =average(A2:A99).
That has some disadvantages, like adding at the bottom is not automatically included in the range, but that's just a matter of getting used to insert before the last line instead.
Using A:A instead is a short-cut that kind-of-works, but if you use the full version, you can avoid your issues.
answered Dec 7 '18 at 22:15
Aganju
8,42231335
add a comment |
The usual way to reference data in a column is to specify the first and last cell, like =average(A2:A99).
That has some disadvantages, like adding at the bottom is not automatically included in the range, but that's just a matter of getting used to insert before the last line instead.
Using A:A instead is a short-cut that kind-of-works, but if you use the full version, you can avoid your issues.
answered Dec 7 '18 at 22:15
Aganju
8,42231335
The usual way to reference data in a column is to specify the first and last cell, like =average(A2:A99).
That has some disadvantages, like adding at the bottom is not automatically included in the range, but that's just a matter of getting used to insert before the last line instead.
Using A:A instead is a short-cut that kind-of-works, but if you use the full version, you can avoid your issues.
answered Dec 7 '18 at 22:15
Aganju
8,42231335
answered Dec 7 '18 at 22:15
Aganju
8,42231335
answered Dec 7 '18 at 22:15
Aganju
8,42231335
answered Dec 7 '18 at 22:15
Aganju
8,42231335
8,42231335
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%2f1381562%2fregular-crashing-in-excel-possible-cause-referencing-entire-column%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
