Force excel workbook to avoid auto recalculation upon opening it on other PC until changes are made
I have the following situation:
I created a rather gigantic excel workbook with a bunch of excel worksheets and a lot of cross-dependencies between worksheets in it and a lot of heavy formulas. I saved this file. When I open it on my laptop it doesn't try to automatically recalculate content since Excel realizes that data didn't change. When I make changes in data recalculation is fast since changes in data will be localized and won't affect the whole workbook making it possible to make adjustments to workbook without spending hours to wait for calculation completion.
When I give a copy of this workbook to anyone else and they open it on their PC it seems that Excel decides (not sure why - wasn't able to find any answer) to recalculate entire workbook. Probably that's a default behavior when excel file is opened on different PC.
Since workbook is huge recalculation of everything in it will take forever
Is there any way to force excel to assume that whichever values are populated in the cells right now are 'correct' (that all cells don't require recalculation) but still preserve the Automatic recalculation behavior when user changes something in the data? Basically, we need to remove 'dirty' status from all cells in the workbook when it is opened on new PC.
excel excel-formula calculation
asked Nov 14 '18 at 12:55
Maksim KhaitovichMaksim Khaitovich
2,67322047
add a comment |
I have the following situation:
I created a rather gigantic excel workbook with a bunch of excel worksheets and a lot of cross-dependencies between worksheets in it and a lot of heavy formulas. I saved this file. When I open it on my laptop it doesn't try to automatically recalculate content since Excel realizes that data didn't change. When I make changes in data recalculation is fast since changes in data will be localized and won't affect the whole workbook making it possible to make adjustments to workbook without spending hours to wait for calculation completion.
When I give a copy of this workbook to anyone else and they open it on their PC it seems that Excel decides (not sure why - wasn't able to find any answer) to recalculate entire workbook. Probably that's a default behavior when excel file is opened on different PC.
Since workbook is huge recalculation of everything in it will take forever
Is there any way to force excel to assume that whichever values are populated in the cells right now are 'correct' (that all cells don't require recalculation) but still preserve the Automatic recalculation behavior when user changes something in the data? Basically, we need to remove 'dirty' status from all cells in the workbook when it is opened on new PC.
excel excel-formula calculation
asked Nov 14 '18 at 12:55
Maksim KhaitovichMaksim Khaitovich
2,67322047
cHECK mrexcel.com/forum/excel-questions/…
– Foxfire And Burns And Burns
Nov 14 '18 at 15:00
And also check superuser.com/questions/184276/…
– Foxfire And Burns And Burns
Nov 14 '18 at 15:00
add a comment |
I have the following situation:
I created a rather gigantic excel workbook with a bunch of excel worksheets and a lot of cross-dependencies between worksheets in it and a lot of heavy formulas. I saved this file. When I open it on my laptop it doesn't try to automatically recalculate content since Excel realizes that data didn't change. When I make changes in data recalculation is fast since changes in data will be localized and won't affect the whole workbook making it possible to make adjustments to workbook without spending hours to wait for calculation completion.
When I give a copy of this workbook to anyone else and they open it on their PC it seems that Excel decides (not sure why - wasn't able to find any answer) to recalculate entire workbook. Probably that's a default behavior when excel file is opened on different PC.
Since workbook is huge recalculation of everything in it will take forever
Is there any way to force excel to assume that whichever values are populated in the cells right now are 'correct' (that all cells don't require recalculation) but still preserve the Automatic recalculation behavior when user changes something in the data? Basically, we need to remove 'dirty' status from all cells in the workbook when it is opened on new PC.
excel excel-formula calculation
asked Nov 14 '18 at 12:55
Maksim KhaitovichMaksim Khaitovich
2,67322047
I have the following situation:
I created a rather gigantic excel workbook with a bunch of excel worksheets and a lot of cross-dependencies between worksheets in it and a lot of heavy formulas. I saved this file. When I open it on my laptop it doesn't try to automatically recalculate content since Excel realizes that data didn't change. When I make changes in data recalculation is fast since changes in data will be localized and won't affect the whole workbook making it possible to make adjustments to workbook without spending hours to wait for calculation completion.
When I give a copy of this workbook to anyone else and they open it on their PC it seems that Excel decides (not sure why - wasn't able to find any answer) to recalculate entire workbook. Probably that's a default behavior when excel file is opened on different PC.
Since workbook is huge recalculation of everything in it will take forever
Is there any way to force excel to assume that whichever values are populated in the cells right now are 'correct' (that all cells don't require recalculation) but still preserve the Automatic recalculation behavior when user changes something in the data? Basically, we need to remove 'dirty' status from all cells in the workbook when it is opened on new PC.
excel excel-formula calculation
excel excel-formula calculation
asked Nov 14 '18 at 12:55
Maksim KhaitovichMaksim Khaitovich
2,67322047
asked Nov 14 '18 at 12:55
Maksim KhaitovichMaksim Khaitovich
2,67322047
edited Nov 15 '18 at 13:24
Maksim Khaitovich
asked Nov 14 '18 at 12:55
Maksim KhaitovichMaksim Khaitovich
2,67322047
asked Nov 14 '18 at 12:55
Maksim KhaitovichMaksim Khaitovich
2,67322047
asked Nov 14 '18 at 12:55
Maksim KhaitovichMaksim Khaitovich
2,67322047
2,67322047
cHECK mrexcel.com/forum/excel-questions/…
– Foxfire And Burns And Burns
Nov 14 '18 at 15:00
And also check superuser.com/questions/184276/…
– Foxfire And Burns And Burns
Nov 14 '18 at 15:00
add a comment |
cHECK mrexcel.com/forum/excel-questions/…
– Foxfire And Burns And Burns
Nov 14 '18 at 15:00
And also check superuser.com/questions/184276/…
– Foxfire And Burns And Burns
Nov 14 '18 at 15:00
cHECK mrexcel.com/forum/excel-questions/…
– Foxfire And Burns And Burns
Nov 14 '18 at 15:00
cHECK mrexcel.com/forum/excel-questions/…
– Foxfire And Burns And Burns
Nov 14 '18 at 15:00
And also check superuser.com/questions/184276/…
– Foxfire And Burns And Burns
Nov 14 '18 at 15:00
And also check superuser.com/questions/184276/…
– Foxfire And Burns And Burns
Nov 14 '18 at 15:00
add a comment |
1 Answer
1
active
oldest
votes
I can not answer Your question, but i may provide a solution for Your problem:
Have You tried to enter
Application.Calculation= xlCalculationManual
Application.CalculateBeforeSave=False
into the direct-window (Ctrl+G while in developers mode)?
You can reactivate the automatic calculation modes later, for example with an "Workbook_Change" -Event, or manually in the direct-window.
I have a few other possible "Work-arounds" in mind, please let me know, if you are interested. This might also help to understand Excels calculations: http://www.decisionmodels.com/calcsecrets.htm
answered Nov 14 '18 at 14:03
foxtrotbravofoxtrotbravo
261
It has nothing to do with the issue at hand. This action will just switch excel to Manual calculation mode and disable calculate before save. If user makes updates to any part of workbook - whole workbook will be recalculate. What I need is a way to remove the 'dirty' status from all cells in the workbook. I can do it with VBA but I was looking for a UI based answer.
– Maksim Khaitovich
Nov 14 '18 at 17:46
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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%2fstackoverflow.com%2fquestions%2f53300755%2fforce-excel-workbook-to-avoid-auto-recalculation-upon-opening-it-on-other-pc-unt%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 can not answer Your question, but i may provide a solution for Your problem:
Have You tried to enter
Application.Calculation= xlCalculationManual
Application.CalculateBeforeSave=False
into the direct-window (Ctrl+G while in developers mode)?
You can reactivate the automatic calculation modes later, for example with an "Workbook_Change" -Event, or manually in the direct-window.
I have a few other possible "Work-arounds" in mind, please let me know, if you are interested. This might also help to understand Excels calculations: http://www.decisionmodels.com/calcsecrets.htm
answered Nov 14 '18 at 14:03
foxtrotbravofoxtrotbravo
261
It has nothing to do with the issue at hand. This action will just switch excel to Manual calculation mode and disable calculate before save. If user makes updates to any part of workbook - whole workbook will be recalculate. What I need is a way to remove the 'dirty' status from all cells in the workbook. I can do it with VBA but I was looking for a UI based answer.
– Maksim Khaitovich
Nov 14 '18 at 17:46
add a comment |
I can not answer Your question, but i may provide a solution for Your problem:
Have You tried to enter
Application.Calculation= xlCalculationManual
Application.CalculateBeforeSave=False
into the direct-window (Ctrl+G while in developers mode)?
You can reactivate the automatic calculation modes later, for example with an "Workbook_Change" -Event, or manually in the direct-window.
I have a few other possible "Work-arounds" in mind, please let me know, if you are interested. This might also help to understand Excels calculations: http://www.decisionmodels.com/calcsecrets.htm
answered Nov 14 '18 at 14:03
foxtrotbravofoxtrotbravo
261
It has nothing to do with the issue at hand. This action will just switch excel to Manual calculation mode and disable calculate before save. If user makes updates to any part of workbook - whole workbook will be recalculate. What I need is a way to remove the 'dirty' status from all cells in the workbook. I can do it with VBA but I was looking for a UI based answer.
– Maksim Khaitovich
Nov 14 '18 at 17:46
add a comment |
I can not answer Your question, but i may provide a solution for Your problem:
Have You tried to enter
Application.Calculation= xlCalculationManual
Application.CalculateBeforeSave=False
into the direct-window (Ctrl+G while in developers mode)?
You can reactivate the automatic calculation modes later, for example with an "Workbook_Change" -Event, or manually in the direct-window.
I have a few other possible "Work-arounds" in mind, please let me know, if you are interested. This might also help to understand Excels calculations: http://www.decisionmodels.com/calcsecrets.htm
answered Nov 14 '18 at 14:03
foxtrotbravofoxtrotbravo
261
I can not answer Your question, but i may provide a solution for Your problem:
Have You tried to enter
Application.Calculation= xlCalculationManual
Application.CalculateBeforeSave=False
into the direct-window (Ctrl+G while in developers mode)?
You can reactivate the automatic calculation modes later, for example with an "Workbook_Change" -Event, or manually in the direct-window.
I have a few other possible "Work-arounds" in mind, please let me know, if you are interested. This might also help to understand Excels calculations: http://www.decisionmodels.com/calcsecrets.htm
answered Nov 14 '18 at 14:03
foxtrotbravofoxtrotbravo
261
answered Nov 14 '18 at 14:03
foxtrotbravofoxtrotbravo
261
answered Nov 14 '18 at 14:03
foxtrotbravofoxtrotbravo
261
answered Nov 14 '18 at 14:03
foxtrotbravofoxtrotbravo
261
261
It has nothing to do with the issue at hand. This action will just switch excel to Manual calculation mode and disable calculate before save. If user makes updates to any part of workbook - whole workbook will be recalculate. What I need is a way to remove the 'dirty' status from all cells in the workbook. I can do it with VBA but I was looking for a UI based answer.
– Maksim Khaitovich
Nov 14 '18 at 17:46
add a comment |
It has nothing to do with the issue at hand. This action will just switch excel to Manual calculation mode and disable calculate before save. If user makes updates to any part of workbook - whole workbook will be recalculate. What I need is a way to remove the 'dirty' status from all cells in the workbook. I can do it with VBA but I was looking for a UI based answer.
– Maksim Khaitovich
Nov 14 '18 at 17:46
It has nothing to do with the issue at hand. This action will just switch excel to Manual calculation mode and disable calculate before save. If user makes updates to any part of workbook - whole workbook will be recalculate. What I need is a way to remove the 'dirty' status from all cells in the workbook. I can do it with VBA but I was looking for a UI based answer.
– Maksim Khaitovich
Nov 14 '18 at 17:46
It has nothing to do with the issue at hand. This action will just switch excel to Manual calculation mode and disable calculate before save. If user makes updates to any part of workbook - whole workbook will be recalculate. What I need is a way to remove the 'dirty' status from all cells in the workbook. I can do it with VBA but I was looking for a UI based answer.
– Maksim Khaitovich
Nov 14 '18 at 17:46
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53300755%2fforce-excel-workbook-to-avoid-auto-recalculation-upon-opening-it-on-other-pc-unt%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
cHECK mrexcel.com/forum/excel-questions/…
– Foxfire And Burns And Burns
Nov 14 '18 at 15:00
And also check superuser.com/questions/184276/…
– Foxfire And Burns And Burns
Nov 14 '18 at 15:00