Excel with VBA, Workbook calculations on Manual, shift-F9 does not work
I have a large excel file with vba codes. When opening the file, excel automatically started calculating, hence it took minutes to even open the file. I set the workbook calculations in File/Options to Manual which solved the problem. However, when I run the macro now, it does not update the cells. Instead it puts the correct formulas in each cell without calculating to find the right value.
Strangely, Shift F9 does not work anymore. Yet when I go to one of the cells and press F2+ENTER the correct value is displayed.
Any idea how I can solve this issue?
excel vba
asked Nov 21 '18 at 13:10
n4pstern4pster
165
add a comment |
I have a large excel file with vba codes. When opening the file, excel automatically started calculating, hence it took minutes to even open the file. I set the workbook calculations in File/Options to Manual which solved the problem. However, when I run the macro now, it does not update the cells. Instead it puts the correct formulas in each cell without calculating to find the right value.
Strangely, Shift F9 does not work anymore. Yet when I go to one of the cells and press F2+ENTER the correct value is displayed.
Any idea how I can solve this issue?
excel vba
asked Nov 21 '18 at 13:10
n4pstern4pster
165
Possible duplicate of Excel is not updating cells, options > formula > workbook calculation set to automatic
– Inarion
Nov 21 '18 at 13:41
CTRL+SHIFT+ALT+F9 does not work unfortunately
– n4pster
Nov 21 '18 at 13:52
What about justF9on its own? If it works, be prepared for a long recalculation time. Alternatively, try puttingApplication.Calculatein/after the relevant line in your macro.
– chillin
Nov 21 '18 at 14:35
Yeah, was wondering aboutF9, too. If that works, there are probably some formulae referencing cells on other sheets that are themselvesdirtybut not reevaluated byShift+F9. AlthoughCtrl+Shift+Alt+F9should have solved that issue... We're stabbing in the dark here.
– Inarion
Nov 21 '18 at 14:41
F9 doesn't work either - no idea why. Peculiarly when I open an empty new workbook, keep the manual calculating settings, and perform some simple calculations SHIFT+F9 does not work either. Only when the option is back on Automatic calculations. No idea whats going on?
– n4pster
Nov 21 '18 at 15:45
add a comment |
I have a large excel file with vba codes. When opening the file, excel automatically started calculating, hence it took minutes to even open the file. I set the workbook calculations in File/Options to Manual which solved the problem. However, when I run the macro now, it does not update the cells. Instead it puts the correct formulas in each cell without calculating to find the right value.
Strangely, Shift F9 does not work anymore. Yet when I go to one of the cells and press F2+ENTER the correct value is displayed.
Any idea how I can solve this issue?
excel vba
asked Nov 21 '18 at 13:10
n4pstern4pster
165
I have a large excel file with vba codes. When opening the file, excel automatically started calculating, hence it took minutes to even open the file. I set the workbook calculations in File/Options to Manual which solved the problem. However, when I run the macro now, it does not update the cells. Instead it puts the correct formulas in each cell without calculating to find the right value.
Strangely, Shift F9 does not work anymore. Yet when I go to one of the cells and press F2+ENTER the correct value is displayed.
Any idea how I can solve this issue?
excel vba
excel vba
asked Nov 21 '18 at 13:10
n4pstern4pster
165
asked Nov 21 '18 at 13:10
n4pstern4pster
165
asked Nov 21 '18 at 13:10
n4pstern4pster
165
asked Nov 21 '18 at 13:10
n4pstern4pster
165
asked Nov 21 '18 at 13:10
n4pstern4pster
165
165
Possible duplicate of Excel is not updating cells, options > formula > workbook calculation set to automatic
– Inarion
Nov 21 '18 at 13:41
CTRL+SHIFT+ALT+F9 does not work unfortunately
– n4pster
Nov 21 '18 at 13:52
What about justF9on its own? If it works, be prepared for a long recalculation time. Alternatively, try puttingApplication.Calculatein/after the relevant line in your macro.
– chillin
Nov 21 '18 at 14:35
Yeah, was wondering aboutF9, too. If that works, there are probably some formulae referencing cells on other sheets that are themselvesdirtybut not reevaluated byShift+F9. AlthoughCtrl+Shift+Alt+F9should have solved that issue... We're stabbing in the dark here.
– Inarion
Nov 21 '18 at 14:41
F9 doesn't work either - no idea why. Peculiarly when I open an empty new workbook, keep the manual calculating settings, and perform some simple calculations SHIFT+F9 does not work either. Only when the option is back on Automatic calculations. No idea whats going on?
– n4pster
Nov 21 '18 at 15:45
add a comment |
Possible duplicate of Excel is not updating cells, options > formula > workbook calculation set to automatic
– Inarion
Nov 21 '18 at 13:41
CTRL+SHIFT+ALT+F9 does not work unfortunately
– n4pster
Nov 21 '18 at 13:52
What about justF9on its own? If it works, be prepared for a long recalculation time. Alternatively, try puttingApplication.Calculatein/after the relevant line in your macro.
– chillin
Nov 21 '18 at 14:35
Yeah, was wondering aboutF9, too. If that works, there are probably some formulae referencing cells on other sheets that are themselvesdirtybut not reevaluated byShift+F9. AlthoughCtrl+Shift+Alt+F9should have solved that issue... We're stabbing in the dark here.
– Inarion
Nov 21 '18 at 14:41
F9 doesn't work either - no idea why. Peculiarly when I open an empty new workbook, keep the manual calculating settings, and perform some simple calculations SHIFT+F9 does not work either. Only when the option is back on Automatic calculations. No idea whats going on?
– n4pster
Nov 21 '18 at 15:45
Possible duplicate of Excel is not updating cells, options > formula > workbook calculation set to automatic
– Inarion
Nov 21 '18 at 13:41
Possible duplicate of Excel is not updating cells, options > formula > workbook calculation set to automatic
– Inarion
Nov 21 '18 at 13:41
CTRL+SHIFT+ALT+F9 does not work unfortunately
– n4pster
Nov 21 '18 at 13:52
CTRL+SHIFT+ALT+F9 does not work unfortunately
– n4pster
Nov 21 '18 at 13:52
What about just
F9 on its own? If it works, be prepared for a long recalculation time. Alternatively, try putting Application.Calculate in/after the relevant line in your macro.– chillin
Nov 21 '18 at 14:35
What about just
F9 on its own? If it works, be prepared for a long recalculation time. Alternatively, try putting Application.Calculate in/after the relevant line in your macro.– chillin
Nov 21 '18 at 14:35
Yeah, was wondering about
F9, too. If that works, there are probably some formulae referencing cells on other sheets that are themselves dirty but not reevaluated by Shift+F9. Although Ctrl+Shift+Alt+F9 should have solved that issue... We're stabbing in the dark here.– Inarion
Nov 21 '18 at 14:41
Yeah, was wondering about
F9, too. If that works, there are probably some formulae referencing cells on other sheets that are themselves dirty but not reevaluated by Shift+F9. Although Ctrl+Shift+Alt+F9 should have solved that issue... We're stabbing in the dark here.– Inarion
Nov 21 '18 at 14:41
F9 doesn't work either - no idea why. Peculiarly when I open an empty new workbook, keep the manual calculating settings, and perform some simple calculations SHIFT+F9 does not work either. Only when the option is back on Automatic calculations. No idea whats going on?
– n4pster
Nov 21 '18 at 15:45
F9 doesn't work either - no idea why. Peculiarly when I open an empty new workbook, keep the manual calculating settings, and perform some simple calculations SHIFT+F9 does not work either. Only when the option is back on Automatic calculations. No idea whats going on?
– n4pster
Nov 21 '18 at 15:45
add a comment |
0
active
oldest
votes
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%2f53412799%2fexcel-with-vba-workbook-calculations-on-manual-shift-f9-does-not-work%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f53412799%2fexcel-with-vba-workbook-calculations-on-manual-shift-f9-does-not-work%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
Possible duplicate of Excel is not updating cells, options > formula > workbook calculation set to automatic
– Inarion
Nov 21 '18 at 13:41
CTRL+SHIFT+ALT+F9 does not work unfortunately
– n4pster
Nov 21 '18 at 13:52
What about just
F9on its own? If it works, be prepared for a long recalculation time. Alternatively, try puttingApplication.Calculatein/after the relevant line in your macro.– chillin
Nov 21 '18 at 14:35
Yeah, was wondering about
F9, too. If that works, there are probably some formulae referencing cells on other sheets that are themselvesdirtybut not reevaluated byShift+F9. AlthoughCtrl+Shift+Alt+F9should have solved that issue... We're stabbing in the dark here.– Inarion
Nov 21 '18 at 14:41
F9 doesn't work either - no idea why. Peculiarly when I open an empty new workbook, keep the manual calculating settings, and perform some simple calculations SHIFT+F9 does not work either. Only when the option is back on Automatic calculations. No idea whats going on?
– n4pster
Nov 21 '18 at 15:45