Why does Windows Defender slow my Excel file saving, even if the xlsm file type is excluded?
I'm experiencing a strange issue with Microsoft Excel (Office 365 MSO 16.0.11126.20234 32B) and Windows Defender running on Window 10 Pro (1809 Build 17763.253 64B) . When I save a macro-enabled Excel (.xlsm) workbook that has been open for a while it takes about 12 seconds to save the file (not acceptable). If I turn off real time protection in Windows Defender then turn it right back on the same file takes 4 seconds to save (acceptable). It will save quickly like that for a while then eventually take over 12 seconds until I flip the real time protection on and off again.
I have cloud-delivered protection and automatic sample submission off in Windows Defender thinking it would eliminate sending the file anywhere. Closing Excel and re-opening the file has no effect. It is not my VBA code as the same issue is seen when I comment out the code and just use the built-in save functionality. The only change I make to correct the issue is turn real time protection off and right back on.
Here is a 1 minute video (watch the immediate window to see the time it takes to save each time): https://www.screencast.com/t/gKOt7LNhsaxc
Also, at the end you can see I have both .xlsm and xlsm files in the Windows Defender exclusion list so I would expect Windows Defender to completely leave these files alone, but that obviously isn't the case. I'm not sure if the exclusion extension should have a period or not. Or if it should be *.xlsm (I can't find any documentation on it.)
Windows Defender Exclusions List
I have a number of people using these files who are complaining of the long save time caused by this issue. Most don't have admin rights so can't flip the real time protection switch.
windows-10 microsoft-excel microsoft-excel-2013 microsoft-excel-2016 windows-defender
asked Jan 21 at 16:24
michaelfmichaelf
161
add a comment |
I'm experiencing a strange issue with Microsoft Excel (Office 365 MSO 16.0.11126.20234 32B) and Windows Defender running on Window 10 Pro (1809 Build 17763.253 64B) . When I save a macro-enabled Excel (.xlsm) workbook that has been open for a while it takes about 12 seconds to save the file (not acceptable). If I turn off real time protection in Windows Defender then turn it right back on the same file takes 4 seconds to save (acceptable). It will save quickly like that for a while then eventually take over 12 seconds until I flip the real time protection on and off again.
I have cloud-delivered protection and automatic sample submission off in Windows Defender thinking it would eliminate sending the file anywhere. Closing Excel and re-opening the file has no effect. It is not my VBA code as the same issue is seen when I comment out the code and just use the built-in save functionality. The only change I make to correct the issue is turn real time protection off and right back on.
Here is a 1 minute video (watch the immediate window to see the time it takes to save each time): https://www.screencast.com/t/gKOt7LNhsaxc
Also, at the end you can see I have both .xlsm and xlsm files in the Windows Defender exclusion list so I would expect Windows Defender to completely leave these files alone, but that obviously isn't the case. I'm not sure if the exclusion extension should have a period or not. Or if it should be *.xlsm (I can't find any documentation on it.)
Windows Defender Exclusions List
I have a number of people using these files who are complaining of the long save time caused by this issue. Most don't have admin rights so can't flip the real time protection switch.
windows-10 microsoft-excel microsoft-excel-2013 microsoft-excel-2016 windows-defender
asked Jan 21 at 16:24
michaelfmichaelf
161
1
I suspect that Windows Defender is not actually checking the file itself, but the program that is creating the file. In this case, Excel. Can you add the Excel executable on the exclusion list?
– Moacir
Feb 5 at 12:44
add a comment |
I'm experiencing a strange issue with Microsoft Excel (Office 365 MSO 16.0.11126.20234 32B) and Windows Defender running on Window 10 Pro (1809 Build 17763.253 64B) . When I save a macro-enabled Excel (.xlsm) workbook that has been open for a while it takes about 12 seconds to save the file (not acceptable). If I turn off real time protection in Windows Defender then turn it right back on the same file takes 4 seconds to save (acceptable). It will save quickly like that for a while then eventually take over 12 seconds until I flip the real time protection on and off again.
I have cloud-delivered protection and automatic sample submission off in Windows Defender thinking it would eliminate sending the file anywhere. Closing Excel and re-opening the file has no effect. It is not my VBA code as the same issue is seen when I comment out the code and just use the built-in save functionality. The only change I make to correct the issue is turn real time protection off and right back on.
Here is a 1 minute video (watch the immediate window to see the time it takes to save each time): https://www.screencast.com/t/gKOt7LNhsaxc
Also, at the end you can see I have both .xlsm and xlsm files in the Windows Defender exclusion list so I would expect Windows Defender to completely leave these files alone, but that obviously isn't the case. I'm not sure if the exclusion extension should have a period or not. Or if it should be *.xlsm (I can't find any documentation on it.)
Windows Defender Exclusions List
I have a number of people using these files who are complaining of the long save time caused by this issue. Most don't have admin rights so can't flip the real time protection switch.
windows-10 microsoft-excel microsoft-excel-2013 microsoft-excel-2016 windows-defender
asked Jan 21 at 16:24
michaelfmichaelf
161
I'm experiencing a strange issue with Microsoft Excel (Office 365 MSO 16.0.11126.20234 32B) and Windows Defender running on Window 10 Pro (1809 Build 17763.253 64B) . When I save a macro-enabled Excel (.xlsm) workbook that has been open for a while it takes about 12 seconds to save the file (not acceptable). If I turn off real time protection in Windows Defender then turn it right back on the same file takes 4 seconds to save (acceptable). It will save quickly like that for a while then eventually take over 12 seconds until I flip the real time protection on and off again.
I have cloud-delivered protection and automatic sample submission off in Windows Defender thinking it would eliminate sending the file anywhere. Closing Excel and re-opening the file has no effect. It is not my VBA code as the same issue is seen when I comment out the code and just use the built-in save functionality. The only change I make to correct the issue is turn real time protection off and right back on.
Here is a 1 minute video (watch the immediate window to see the time it takes to save each time): https://www.screencast.com/t/gKOt7LNhsaxc
Also, at the end you can see I have both .xlsm and xlsm files in the Windows Defender exclusion list so I would expect Windows Defender to completely leave these files alone, but that obviously isn't the case. I'm not sure if the exclusion extension should have a period or not. Or if it should be *.xlsm (I can't find any documentation on it.)
Windows Defender Exclusions List
I have a number of people using these files who are complaining of the long save time caused by this issue. Most don't have admin rights so can't flip the real time protection switch.
windows-10 microsoft-excel microsoft-excel-2013 microsoft-excel-2016 windows-defender
windows-10 microsoft-excel microsoft-excel-2013 microsoft-excel-2016 windows-defender
asked Jan 21 at 16:24
michaelfmichaelf
161
asked Jan 21 at 16:24
michaelfmichaelf
161
asked Jan 21 at 16:24
michaelfmichaelf
161
asked Jan 21 at 16:24
michaelfmichaelf
161
asked Jan 21 at 16:24
michaelfmichaelf
161
161
1
I suspect that Windows Defender is not actually checking the file itself, but the program that is creating the file. In this case, Excel. Can you add the Excel executable on the exclusion list?
– Moacir
Feb 5 at 12:44
add a comment |
1
I suspect that Windows Defender is not actually checking the file itself, but the program that is creating the file. In this case, Excel. Can you add the Excel executable on the exclusion list?
– Moacir
Feb 5 at 12:44
1
1
I suspect that Windows Defender is not actually checking the file itself, but the program that is creating the file. In this case, Excel. Can you add the Excel executable on the exclusion list?
– Moacir
Feb 5 at 12:44
I suspect that Windows Defender is not actually checking the file itself, but the program that is creating the file. In this case, Excel. Can you add the Excel executable on the exclusion list?
– Moacir
Feb 5 at 12:44
add a comment |
1 Answer
1
active
oldest
votes
Thanks moacir. I added EXCEL.EXE to the Windows Defender exclusion list and the save time went from 12 seconds to about 2. So it seems to have worked on my machine.
Problem is my clients won't exclude the entire application (they just want to exclude certain files or folders). I can't blame them. I'm going to add a digital signature to my Excel VBA to see if that helps (but not confident that it will).
Thanks again.
answered Feb 7 at 2:37
michaelfmichaelf
161
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%2f1396683%2fwhy-does-windows-defender-slow-my-excel-file-saving-even-if-the-xlsm-file-type%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
Thanks moacir. I added EXCEL.EXE to the Windows Defender exclusion list and the save time went from 12 seconds to about 2. So it seems to have worked on my machine.
Problem is my clients won't exclude the entire application (they just want to exclude certain files or folders). I can't blame them. I'm going to add a digital signature to my Excel VBA to see if that helps (but not confident that it will).
Thanks again.
answered Feb 7 at 2:37
michaelfmichaelf
161
add a comment |
Thanks moacir. I added EXCEL.EXE to the Windows Defender exclusion list and the save time went from 12 seconds to about 2. So it seems to have worked on my machine.
Problem is my clients won't exclude the entire application (they just want to exclude certain files or folders). I can't blame them. I'm going to add a digital signature to my Excel VBA to see if that helps (but not confident that it will).
Thanks again.
answered Feb 7 at 2:37
michaelfmichaelf
161
add a comment |
Thanks moacir. I added EXCEL.EXE to the Windows Defender exclusion list and the save time went from 12 seconds to about 2. So it seems to have worked on my machine.
Problem is my clients won't exclude the entire application (they just want to exclude certain files or folders). I can't blame them. I'm going to add a digital signature to my Excel VBA to see if that helps (but not confident that it will).
Thanks again.
answered Feb 7 at 2:37
michaelfmichaelf
161
Thanks moacir. I added EXCEL.EXE to the Windows Defender exclusion list and the save time went from 12 seconds to about 2. So it seems to have worked on my machine.
Problem is my clients won't exclude the entire application (they just want to exclude certain files or folders). I can't blame them. I'm going to add a digital signature to my Excel VBA to see if that helps (but not confident that it will).
Thanks again.
answered Feb 7 at 2:37
michaelfmichaelf
161
answered Feb 7 at 2:37
michaelfmichaelf
161
answered Feb 7 at 2:37
michaelfmichaelf
161
answered Feb 7 at 2:37
michaelfmichaelf
161
161
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%2f1396683%2fwhy-does-windows-defender-slow-my-excel-file-saving-even-if-the-xlsm-file-type%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
1
I suspect that Windows Defender is not actually checking the file itself, but the program that is creating the file. In this case, Excel. Can you add the Excel executable on the exclusion list?
– Moacir
Feb 5 at 12:44