how to run a faster Excel or how to free up RAM to avoid Excel freeze or slow response
I frequently need to run operations in big Excel tables (e.g. 100000 rows x 1000 columns - file size >100 MB) and likely due to the file size, when I try to do one calculation across the whole table, it takes longer than "expected" (?) or freezes up. (on the side, I need to have my MS outlook open, some MS WORD files and an internet browser with multiple tabs).
Q1. any suggestion how to operate Excel (i.e. work on a large spreadsheet) faster
Q2. does freeing up RAM help run a faster Excel
Q3. any suggestion how to operate a big Excel table fast or without crashing Excel ?
microsoft-excel
asked Dec 19 '18 at 16:28
B Chen
16519
add a comment |
I frequently need to run operations in big Excel tables (e.g. 100000 rows x 1000 columns - file size >100 MB) and likely due to the file size, when I try to do one calculation across the whole table, it takes longer than "expected" (?) or freezes up. (on the side, I need to have my MS outlook open, some MS WORD files and an internet browser with multiple tabs).
Q1. any suggestion how to operate Excel (i.e. work on a large spreadsheet) faster
Q2. does freeing up RAM help run a faster Excel
Q3. any suggestion how to operate a big Excel table fast or without crashing Excel ?
microsoft-excel
asked Dec 19 '18 at 16:28
B Chen
16519
4
tbh, if you're up to that kind of size you're into database territory, not spreadsheet.
– Tetsujin
Dec 19 '18 at 17:17
@Tetsujin, so you are suggesting that I convert the spreadsheet into a format that is compatible with database management?
– B Chen
Dec 19 '18 at 17:22
3
You're talking 100 million potential entries + calculations... yes. A database would separate the calculation from the entries, at least. Spreadsheets are just not designed for that kind of punishment.
– Tetsujin
Dec 19 '18 at 17:25
2
I expect you'll find that if you leave the "frozen" excel alone for a while (with high CPU usage), it'll eventually complete its operation and become responsive again. That said... as @Tetsujin has pointed out, what you really want for this volume of data is a database - e.g: MySQL. I'd never even contemplate dealing with a 100 MB Excel file.
– Attie
Dec 19 '18 at 18:15
add a comment |
I frequently need to run operations in big Excel tables (e.g. 100000 rows x 1000 columns - file size >100 MB) and likely due to the file size, when I try to do one calculation across the whole table, it takes longer than "expected" (?) or freezes up. (on the side, I need to have my MS outlook open, some MS WORD files and an internet browser with multiple tabs).
Q1. any suggestion how to operate Excel (i.e. work on a large spreadsheet) faster
Q2. does freeing up RAM help run a faster Excel
Q3. any suggestion how to operate a big Excel table fast or without crashing Excel ?
microsoft-excel
asked Dec 19 '18 at 16:28
B Chen
16519
I frequently need to run operations in big Excel tables (e.g. 100000 rows x 1000 columns - file size >100 MB) and likely due to the file size, when I try to do one calculation across the whole table, it takes longer than "expected" (?) or freezes up. (on the side, I need to have my MS outlook open, some MS WORD files and an internet browser with multiple tabs).
Q1. any suggestion how to operate Excel (i.e. work on a large spreadsheet) faster
Q2. does freeing up RAM help run a faster Excel
Q3. any suggestion how to operate a big Excel table fast or without crashing Excel ?
microsoft-excel
microsoft-excel
asked Dec 19 '18 at 16:28
B Chen
16519
asked Dec 19 '18 at 16:28
B Chen
16519
asked Dec 19 '18 at 16:28
B Chen
16519
asked Dec 19 '18 at 16:28
B Chen
16519
asked Dec 19 '18 at 16:28
B Chen
16519
16519
4
tbh, if you're up to that kind of size you're into database territory, not spreadsheet.
– Tetsujin
Dec 19 '18 at 17:17
@Tetsujin, so you are suggesting that I convert the spreadsheet into a format that is compatible with database management?
– B Chen
Dec 19 '18 at 17:22
3
You're talking 100 million potential entries + calculations... yes. A database would separate the calculation from the entries, at least. Spreadsheets are just not designed for that kind of punishment.
– Tetsujin
Dec 19 '18 at 17:25
2
I expect you'll find that if you leave the "frozen" excel alone for a while (with high CPU usage), it'll eventually complete its operation and become responsive again. That said... as @Tetsujin has pointed out, what you really want for this volume of data is a database - e.g: MySQL. I'd never even contemplate dealing with a 100 MB Excel file.
– Attie
Dec 19 '18 at 18:15
add a comment |
4
tbh, if you're up to that kind of size you're into database territory, not spreadsheet.
– Tetsujin
Dec 19 '18 at 17:17
@Tetsujin, so you are suggesting that I convert the spreadsheet into a format that is compatible with database management?
– B Chen
Dec 19 '18 at 17:22
3
You're talking 100 million potential entries + calculations... yes. A database would separate the calculation from the entries, at least. Spreadsheets are just not designed for that kind of punishment.
– Tetsujin
Dec 19 '18 at 17:25
2
I expect you'll find that if you leave the "frozen" excel alone for a while (with high CPU usage), it'll eventually complete its operation and become responsive again. That said... as @Tetsujin has pointed out, what you really want for this volume of data is a database - e.g: MySQL. I'd never even contemplate dealing with a 100 MB Excel file.
– Attie
Dec 19 '18 at 18:15
4
4
tbh, if you're up to that kind of size you're into database territory, not spreadsheet.
– Tetsujin
Dec 19 '18 at 17:17
tbh, if you're up to that kind of size you're into database territory, not spreadsheet.
– Tetsujin
Dec 19 '18 at 17:17
@Tetsujin, so you are suggesting that I convert the spreadsheet into a format that is compatible with database management?
– B Chen
Dec 19 '18 at 17:22
@Tetsujin, so you are suggesting that I convert the spreadsheet into a format that is compatible with database management?
– B Chen
Dec 19 '18 at 17:22
3
3
You're talking 100 million potential entries + calculations... yes. A database would separate the calculation from the entries, at least. Spreadsheets are just not designed for that kind of punishment.
– Tetsujin
Dec 19 '18 at 17:25
You're talking 100 million potential entries + calculations... yes. A database would separate the calculation from the entries, at least. Spreadsheets are just not designed for that kind of punishment.
– Tetsujin
Dec 19 '18 at 17:25
2
2
I expect you'll find that if you leave the "frozen" excel alone for a while (with high CPU usage), it'll eventually complete its operation and become responsive again. That said... as @Tetsujin has pointed out, what you really want for this volume of data is a database - e.g: MySQL. I'd never even contemplate dealing with a 100 MB Excel file.
– Attie
Dec 19 '18 at 18:15
I expect you'll find that if you leave the "frozen" excel alone for a while (with high CPU usage), it'll eventually complete its operation and become responsive again. That said... as @Tetsujin has pointed out, what you really want for this volume of data is a database - e.g: MySQL. I'd never even contemplate dealing with a 100 MB Excel file.
– Attie
Dec 19 '18 at 18:15
add a comment |
1 Answer
1
active
oldest
votes
First moving to a database is the best course of action as others have pointed out.
More memory helps.
Migrate to an SSD over a hard drive.
These will both help. However, I suggest looking up 1st through 5th normal form in regards to databases and make a database that follows those rules.
answered Dec 19 '18 at 22:24
cybernard
9,95431525
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%2f1385968%2fhow-to-run-a-faster-excel-or-how-to-free-up-ram-to-avoid-excel-freeze-or-slow-re%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
First moving to a database is the best course of action as others have pointed out.
More memory helps.
Migrate to an SSD over a hard drive.
These will both help. However, I suggest looking up 1st through 5th normal form in regards to databases and make a database that follows those rules.
answered Dec 19 '18 at 22:24
cybernard
9,95431525
add a comment |
First moving to a database is the best course of action as others have pointed out.
More memory helps.
Migrate to an SSD over a hard drive.
These will both help. However, I suggest looking up 1st through 5th normal form in regards to databases and make a database that follows those rules.
answered Dec 19 '18 at 22:24
cybernard
9,95431525
add a comment |
First moving to a database is the best course of action as others have pointed out.
More memory helps.
Migrate to an SSD over a hard drive.
These will both help. However, I suggest looking up 1st through 5th normal form in regards to databases and make a database that follows those rules.
answered Dec 19 '18 at 22:24
cybernard
9,95431525
First moving to a database is the best course of action as others have pointed out.
More memory helps.
Migrate to an SSD over a hard drive.
These will both help. However, I suggest looking up 1st through 5th normal form in regards to databases and make a database that follows those rules.
answered Dec 19 '18 at 22:24
cybernard
9,95431525
answered Dec 19 '18 at 22:24
cybernard
9,95431525
answered Dec 19 '18 at 22:24
cybernard
9,95431525
answered Dec 19 '18 at 22:24
cybernard
9,95431525
9,95431525
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%2f1385968%2fhow-to-run-a-faster-excel-or-how-to-free-up-ram-to-avoid-excel-freeze-or-slow-re%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
4
tbh, if you're up to that kind of size you're into database territory, not spreadsheet.
– Tetsujin
Dec 19 '18 at 17:17
@Tetsujin, so you are suggesting that I convert the spreadsheet into a format that is compatible with database management?
– B Chen
Dec 19 '18 at 17:22
3
You're talking 100 million potential entries + calculations... yes. A database would separate the calculation from the entries, at least. Spreadsheets are just not designed for that kind of punishment.
– Tetsujin
Dec 19 '18 at 17:25
2
I expect you'll find that if you leave the "frozen" excel alone for a while (with high CPU usage), it'll eventually complete its operation and become responsive again. That said... as @Tetsujin has pointed out, what you really want for this volume of data is a database - e.g: MySQL. I'd never even contemplate dealing with a 100 MB Excel file.
– Attie
Dec 19 '18 at 18:15