Excel file larger after saving and going very slow
I have a 3.5Mb excel workbook with several tabs, only one macro and apparently not pulling data from anywhere in the outside. Nevertheless, when I open it (it takes an obscene amount of time) and I do Ctrl+S it saves itself (again after an unbelievable amount of time) and it weights 4.3Mb now and during the saving procedure an empty text file is created. I have done this repeatedly as I have the 3.5Mb file in my email with the same outcome.
Neither tweaking the main options nor rebooting the PC and excel has yield any success.
Any help would be much appreciated, I am working on a windows 10 and MicrosoftOffice 365 ProPlus with excel version 1808.
microsoft-excel memory macros
edited Feb 26 at 20:21
DavidPostill♦
108k27235270
asked Feb 26 at 19:15
alsacoalsaco
1
add a comment |
I have a 3.5Mb excel workbook with several tabs, only one macro and apparently not pulling data from anywhere in the outside. Nevertheless, when I open it (it takes an obscene amount of time) and I do Ctrl+S it saves itself (again after an unbelievable amount of time) and it weights 4.3Mb now and during the saving procedure an empty text file is created. I have done this repeatedly as I have the 3.5Mb file in my email with the same outcome.
Neither tweaking the main options nor rebooting the PC and excel has yield any success.
Any help would be much appreciated, I am working on a windows 10 and MicrosoftOffice 365 ProPlus with excel version 1808.
microsoft-excel memory macros
edited Feb 26 at 20:21
DavidPostill♦
108k27235270
asked Feb 26 at 19:15
alsacoalsaco
1
What happens if you disable the macro? If there is more than one worksheet look into the file structure to see if a particular sheet is significantly bigger than others. If yes, is it a work sheet that the macro affects? if no, see if a Clear All" of all empty seeming cells helps. If not, you may need to copy only those cells with content to a new sheet and delete the problem sheet.
– cybernetic.nomad
Feb 26 at 19:32
Did you check to see if there are formulas? Possibly calculation is occurring?
– datatoo
Feb 26 at 21:14
Thanks for the quick responses. If I delete the macro and save the file the behavior is the same, a heavier file is saved and it won't open afterwards, it says recovering and stalls. Doing as suggested, looking into the file structure I see that there are notable differences in /xl and more particularly in drawings. Is it an issue of how I am saving the file (I have no trouble with the 3.9Mb file)? Furthermore, how can I detect the bottle neck that is causing this trouble from the xml? Thanks for everything
– alsaco
Feb 26 at 22:25
Look in `xlworksheets` is one of the XMLs there huge compared to the others?
– cybernetic.nomad
Feb 27 at 15:16
add a comment |
I have a 3.5Mb excel workbook with several tabs, only one macro and apparently not pulling data from anywhere in the outside. Nevertheless, when I open it (it takes an obscene amount of time) and I do Ctrl+S it saves itself (again after an unbelievable amount of time) and it weights 4.3Mb now and during the saving procedure an empty text file is created. I have done this repeatedly as I have the 3.5Mb file in my email with the same outcome.
Neither tweaking the main options nor rebooting the PC and excel has yield any success.
Any help would be much appreciated, I am working on a windows 10 and MicrosoftOffice 365 ProPlus with excel version 1808.
microsoft-excel memory macros
edited Feb 26 at 20:21
DavidPostill♦
108k27235270
asked Feb 26 at 19:15
alsacoalsaco
1
I have a 3.5Mb excel workbook with several tabs, only one macro and apparently not pulling data from anywhere in the outside. Nevertheless, when I open it (it takes an obscene amount of time) and I do Ctrl+S it saves itself (again after an unbelievable amount of time) and it weights 4.3Mb now and during the saving procedure an empty text file is created. I have done this repeatedly as I have the 3.5Mb file in my email with the same outcome.
Neither tweaking the main options nor rebooting the PC and excel has yield any success.
Any help would be much appreciated, I am working on a windows 10 and MicrosoftOffice 365 ProPlus with excel version 1808.
microsoft-excel memory macros
microsoft-excel memory macros
edited Feb 26 at 20:21
DavidPostill♦
108k27235270
asked Feb 26 at 19:15
alsacoalsaco
1
edited Feb 26 at 20:21
DavidPostill♦
108k27235270
asked Feb 26 at 19:15
alsacoalsaco
1
edited Feb 26 at 20:21
DavidPostill♦
108k27235270
edited Feb 26 at 20:21
DavidPostill♦
108k27235270
edited Feb 26 at 20:21
DavidPostill♦
108k27235270
108k27235270
asked Feb 26 at 19:15
alsacoalsaco
1
asked Feb 26 at 19:15
alsacoalsaco
1
asked Feb 26 at 19:15
alsacoalsaco
1
1
What happens if you disable the macro? If there is more than one worksheet look into the file structure to see if a particular sheet is significantly bigger than others. If yes, is it a work sheet that the macro affects? if no, see if a Clear All" of all empty seeming cells helps. If not, you may need to copy only those cells with content to a new sheet and delete the problem sheet.
– cybernetic.nomad
Feb 26 at 19:32
Did you check to see if there are formulas? Possibly calculation is occurring?
– datatoo
Feb 26 at 21:14
Thanks for the quick responses. If I delete the macro and save the file the behavior is the same, a heavier file is saved and it won't open afterwards, it says recovering and stalls. Doing as suggested, looking into the file structure I see that there are notable differences in /xl and more particularly in drawings. Is it an issue of how I am saving the file (I have no trouble with the 3.9Mb file)? Furthermore, how can I detect the bottle neck that is causing this trouble from the xml? Thanks for everything
– alsaco
Feb 26 at 22:25
Look in `xlworksheets` is one of the XMLs there huge compared to the others?
– cybernetic.nomad
Feb 27 at 15:16
add a comment |
What happens if you disable the macro? If there is more than one worksheet look into the file structure to see if a particular sheet is significantly bigger than others. If yes, is it a work sheet that the macro affects? if no, see if a Clear All" of all empty seeming cells helps. If not, you may need to copy only those cells with content to a new sheet and delete the problem sheet.
– cybernetic.nomad
Feb 26 at 19:32
Did you check to see if there are formulas? Possibly calculation is occurring?
– datatoo
Feb 26 at 21:14
Thanks for the quick responses. If I delete the macro and save the file the behavior is the same, a heavier file is saved and it won't open afterwards, it says recovering and stalls. Doing as suggested, looking into the file structure I see that there are notable differences in /xl and more particularly in drawings. Is it an issue of how I am saving the file (I have no trouble with the 3.9Mb file)? Furthermore, how can I detect the bottle neck that is causing this trouble from the xml? Thanks for everything
– alsaco
Feb 26 at 22:25
Look in `xlworksheets` is one of the XMLs there huge compared to the others?
– cybernetic.nomad
Feb 27 at 15:16
What happens if you disable the macro? If there is more than one worksheet look into the file structure to see if a particular sheet is significantly bigger than others. If yes, is it a work sheet that the macro affects? if no, see if a Clear All" of all empty seeming cells helps. If not, you may need to copy only those cells with content to a new sheet and delete the problem sheet.
– cybernetic.nomad
Feb 26 at 19:32
What happens if you disable the macro? If there is more than one worksheet look into the file structure to see if a particular sheet is significantly bigger than others. If yes, is it a work sheet that the macro affects? if no, see if a Clear All" of all empty seeming cells helps. If not, you may need to copy only those cells with content to a new sheet and delete the problem sheet.
– cybernetic.nomad
Feb 26 at 19:32
Did you check to see if there are formulas? Possibly calculation is occurring?
– datatoo
Feb 26 at 21:14
Did you check to see if there are formulas? Possibly calculation is occurring?
– datatoo
Feb 26 at 21:14
Thanks for the quick responses. If I delete the macro and save the file the behavior is the same, a heavier file is saved and it won't open afterwards, it says recovering and stalls. Doing as suggested, looking into the file structure I see that there are notable differences in /xl and more particularly in drawings. Is it an issue of how I am saving the file (I have no trouble with the 3.9Mb file)? Furthermore, how can I detect the bottle neck that is causing this trouble from the xml? Thanks for everything
– alsaco
Feb 26 at 22:25
Thanks for the quick responses. If I delete the macro and save the file the behavior is the same, a heavier file is saved and it won't open afterwards, it says recovering and stalls. Doing as suggested, looking into the file structure I see that there are notable differences in /xl and more particularly in drawings. Is it an issue of how I am saving the file (I have no trouble with the 3.9Mb file)? Furthermore, how can I detect the bottle neck that is causing this trouble from the xml? Thanks for everything
– alsaco
Feb 26 at 22:25
Look in `xlworksheets` is one of the XMLs there huge compared to the others?
– cybernetic.nomad
Feb 27 at 15:16
Look in `xlworksheets` is one of the XMLs there huge compared to the others?
– cybernetic.nomad
Feb 27 at 15:16
add a comment |
1 Answer
1
active
oldest
votes
Sometimes, a cell is edited or formatted at the very end (bottom or right) of excel, which results in all one million empty rows (columns) being saved too.
Try this: hit CTRL+END. It should hop to the last field with data in your sheet. If it goes to the very bottom (or very right), select all one million rows (columns) between your last data and the end, and delete them. Then save, close, and open again. The problem should be gone.
answered Feb 27 at 14:29
AganjuAganju
8,62131437
add a comment |
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%2f1409664%2fexcel-file-larger-after-saving-and-going-very-slow%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
Sometimes, a cell is edited or formatted at the very end (bottom or right) of excel, which results in all one million empty rows (columns) being saved too.
Try this: hit CTRL+END. It should hop to the last field with data in your sheet. If it goes to the very bottom (or very right), select all one million rows (columns) between your last data and the end, and delete them. Then save, close, and open again. The problem should be gone.
answered Feb 27 at 14:29
AganjuAganju
8,62131437
add a comment |
Sometimes, a cell is edited or formatted at the very end (bottom or right) of excel, which results in all one million empty rows (columns) being saved too.
Try this: hit CTRL+END. It should hop to the last field with data in your sheet. If it goes to the very bottom (or very right), select all one million rows (columns) between your last data and the end, and delete them. Then save, close, and open again. The problem should be gone.
answered Feb 27 at 14:29
AganjuAganju
8,62131437
add a comment |
Sometimes, a cell is edited or formatted at the very end (bottom or right) of excel, which results in all one million empty rows (columns) being saved too.
Try this: hit CTRL+END. It should hop to the last field with data in your sheet. If it goes to the very bottom (or very right), select all one million rows (columns) between your last data and the end, and delete them. Then save, close, and open again. The problem should be gone.
answered Feb 27 at 14:29
AganjuAganju
8,62131437
Sometimes, a cell is edited or formatted at the very end (bottom or right) of excel, which results in all one million empty rows (columns) being saved too.
Try this: hit CTRL+END. It should hop to the last field with data in your sheet. If it goes to the very bottom (or very right), select all one million rows (columns) between your last data and the end, and delete them. Then save, close, and open again. The problem should be gone.
answered Feb 27 at 14:29
AganjuAganju
8,62131437
answered Feb 27 at 14:29
AganjuAganju
8,62131437
answered Feb 27 at 14:29
AganjuAganju
8,62131437
answered Feb 27 at 14:29
AganjuAganju
8,62131437
8,62131437
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%2f1409664%2fexcel-file-larger-after-saving-and-going-very-slow%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
What happens if you disable the macro? If there is more than one worksheet look into the file structure to see if a particular sheet is significantly bigger than others. If yes, is it a work sheet that the macro affects? if no, see if a Clear All" of all empty seeming cells helps. If not, you may need to copy only those cells with content to a new sheet and delete the problem sheet.
– cybernetic.nomad
Feb 26 at 19:32
Did you check to see if there are formulas? Possibly calculation is occurring?
– datatoo
Feb 26 at 21:14
Thanks for the quick responses. If I delete the macro and save the file the behavior is the same, a heavier file is saved and it won't open afterwards, it says recovering and stalls. Doing as suggested, looking into the file structure I see that there are notable differences in /xl and more particularly in drawings. Is it an issue of how I am saving the file (I have no trouble with the 3.9Mb file)? Furthermore, how can I detect the bottle neck that is causing this trouble from the xml? Thanks for everything
– alsaco
Feb 26 at 22:25
Look in `xlworksheets` is one of the XMLs there huge compared to the others?
– cybernetic.nomad
Feb 27 at 15:16