Manually updating Excel worksheets through VBA doesn't work when automatic calculating is disabled ...
pgfplots: How to draw a tangent graph below two others?
Early programmable calculators with RS-232
Car headlights in a world without electricity
Do I need to write [sic] when including a quotation with a number less than 10 that isn't written out?
logical reads on global temp table, but not on session-level temp table
Mathematica command that allows it to read my intentions
What steps are necessary to read a Modern SSD in Medieval Europe?
Salesforce opportunity stages
What is the difference between 'contrib' and 'non-free' packages repositories?
How should I connect my cat5 cable to connectors having an orange-green line?
Why do we say “un seul M” and not “une seule M” even though M is a “consonne”?
Is it OK to decorate a log book cover?
Planeswalker Ability and Death Timing
Masking layers by a vector polygon layer in QGIS
What difference does it make matching a word with/without a trailing whitespace?
Why can't we say "I have been having a dog"?
Calculating discount not working
Prodigo = pro + ago?
How can I replace x-axis labels with pre-determined symbols?
Why did the Drakh emissary look so blurred in S04:E11 "Lines of Communication"?
Find a path from s to t using as few red nodes as possible
Why was Sir Cadogan fired?
How do I secure a TV wall mount?
Does int main() need a declaration on C++?
Manually updating Excel worksheets through VBA doesn't work when automatic calculating is disabled
The Next CEO of Stack OverflowUsing excel sheet as a functionExcel data doesn't update after data injection from an access dbOpening an Excel 2003 workbook in Excel 2010 32-bit causes bogus circular reference and crashesOpening an Excel 2003 workbook in Excel 2010 32-bit causes bogus circular reference and crashesExcel VBA updating graph dataExcel creates non-existent worksheets in VBA Project ExplorerExcel: What can cause manual calculation / F9 to stop recalculating?Excel VBA recalculate on all worksheets when open and tab changeHow to split multiple worksheets of data by column value and output to separate files?Excel 365 Can't Update Link
In our daily work we disable automatic calculation in Excel by VBA,
and decide when a cell or sheet is updated.
Worksheets("Sheet1").Calculate does not seem to work any more after the update released on February 12th, 2019. See the following link:
https://support.microsoft.com/en-us/help/4462115/description-of-the-security-update-for-excel-2016-february-12-2019
I've tested this in Office 2013 and 2016/365;
it still works in 2013, but not in 2016/365.
Has anyone else experienced this issue?
NB: Current workaround is to define a range to be updated
instead of the entire sheet, which works fine.
microsoft-excel vba microsoft-excel-2016 microsoft-excel-365
edited 4 hours ago
Scott
16.1k113990
asked 12 hours ago
KevinKevin
1
New contributor
Kevin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
In our daily work we disable automatic calculation in Excel by VBA,
and decide when a cell or sheet is updated.
Worksheets("Sheet1").Calculate does not seem to work any more after the update released on February 12th, 2019. See the following link:
https://support.microsoft.com/en-us/help/4462115/description-of-the-security-update-for-excel-2016-february-12-2019
I've tested this in Office 2013 and 2016/365;
it still works in 2013, but not in 2016/365.
Has anyone else experienced this issue?
NB: Current workaround is to define a range to be updated
instead of the entire sheet, which works fine.
microsoft-excel vba microsoft-excel-2016 microsoft-excel-365
edited 4 hours ago
Scott
16.1k113990
asked 12 hours ago
KevinKevin
1
New contributor
Kevin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Just checking. Events and Screen update are set to T?Application.EnableEvents = True : Application.ScreenUpdating = Trueand doesCTRL+F9works? if yes, thenSendKeys "{F9}"after activatingSheet1should work
– M-M
5 hours ago
add a comment |
In our daily work we disable automatic calculation in Excel by VBA,
and decide when a cell or sheet is updated.
Worksheets("Sheet1").Calculate does not seem to work any more after the update released on February 12th, 2019. See the following link:
https://support.microsoft.com/en-us/help/4462115/description-of-the-security-update-for-excel-2016-february-12-2019
I've tested this in Office 2013 and 2016/365;
it still works in 2013, but not in 2016/365.
Has anyone else experienced this issue?
NB: Current workaround is to define a range to be updated
instead of the entire sheet, which works fine.
microsoft-excel vba microsoft-excel-2016 microsoft-excel-365
edited 4 hours ago
Scott
16.1k113990
asked 12 hours ago
KevinKevin
1
New contributor
Kevin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
In our daily work we disable automatic calculation in Excel by VBA,
and decide when a cell or sheet is updated.
Worksheets("Sheet1").Calculate does not seem to work any more after the update released on February 12th, 2019. See the following link:
https://support.microsoft.com/en-us/help/4462115/description-of-the-security-update-for-excel-2016-february-12-2019
I've tested this in Office 2013 and 2016/365;
it still works in 2013, but not in 2016/365.
Has anyone else experienced this issue?
NB: Current workaround is to define a range to be updated
instead of the entire sheet, which works fine.
microsoft-excel vba microsoft-excel-2016 microsoft-excel-365
microsoft-excel vba microsoft-excel-2016 microsoft-excel-365
edited 4 hours ago
Scott
16.1k113990
asked 12 hours ago
KevinKevin
1
New contributor
Kevin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 4 hours ago
Scott
16.1k113990
asked 12 hours ago
KevinKevin
1
New contributor
Kevin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 4 hours ago
Scott
16.1k113990
edited 4 hours ago
Scott
16.1k113990
edited 4 hours ago
Scott
16.1k113990
16.1k113990
asked 12 hours ago
KevinKevin
1
New contributor
Kevin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 12 hours ago
KevinKevin
1
asked 12 hours ago
KevinKevin
1
1
New contributor
Kevin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Kevin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Kevin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Just checking. Events and Screen update are set to T?Application.EnableEvents = True : Application.ScreenUpdating = Trueand doesCTRL+F9works? if yes, thenSendKeys "{F9}"after activatingSheet1should work
– M-M
5 hours ago
add a comment |
Just checking. Events and Screen update are set to T?Application.EnableEvents = True : Application.ScreenUpdating = Trueand doesCTRL+F9works? if yes, thenSendKeys "{F9}"after activatingSheet1should work
– M-M
5 hours ago
Just checking. Events and Screen update are set to T?
Application.EnableEvents = True : Application.ScreenUpdating = True and does CTRL+F9 works? if yes, then SendKeys "{F9}" after activating Sheet1 should work– M-M
5 hours ago
Just checking. Events and Screen update are set to T?
Application.EnableEvents = True : Application.ScreenUpdating = True and does CTRL+F9 works? if yes, then SendKeys "{F9}" after activating Sheet1 should work– M-M
5 hours ago
add a comment |
0
active
oldest
votes
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
});
}
});
Kevin is a new contributor. Be nice, and check out our Code of Conduct.
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%2f1420002%2fmanually-updating-excel-worksheets-through-vba-doesnt-work-when-automatic-calcu%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
Kevin is a new contributor. Be nice, and check out our Code of Conduct.
Kevin is a new contributor. Be nice, and check out our Code of Conduct.
Kevin is a new contributor. Be nice, and check out our Code of Conduct.
Kevin is a new contributor. Be nice, and check out our Code of Conduct.
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%2f1420002%2fmanually-updating-excel-worksheets-through-vba-doesnt-work-when-automatic-calcu%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
Just checking. Events and Screen update are set to T?
Application.EnableEvents = True : Application.ScreenUpdating = Trueand doesCTRL+F9works? if yes, thenSendKeys "{F9}"after activatingSheet1should work– M-M
5 hours ago