How do I fix a long delay in Excel 2016?
I just bought a new computer (Lenovo ThinkPad E560 with Solid State Drive and Intel Core i5 processor) with Windows 7 and the local version of Office 2016 (NOT Office 365). I have noticed when using Excel 2016 that there is sometimes a long delay when using the buttons in the top ribbon to paste values or to change the fill color of a cell. Oddly, the delay does not happen when I do a regular paste and then use the drop-down menu that appears in the file immediately after the paste to select paste values--it is only when I use the paste values command underneath the paste button in the top ribbon. The delay varies in length, but sometimes seems as long as 30 seconds or more. During this time, Excel essentially freezes up and I am unable to do anything with any open Excel window. The delay eventually clears, the operation (whether pasting or changing cell fill color) completes, and I am able to use Excel normally again. At first I thought it had to do with the number of cells being affected, but this has happened with large and small cell ranges alike, so I don't think that is the issue. The problem is intermittent. Has anyone else seen something like this? Do I need to reinstall Office?
microsoft-excel microsoft-office microsoft-excel-2016 delay
asked Aug 6 '16 at 19:41
HaroldFinchHaroldFinch
913
add a comment |
I just bought a new computer (Lenovo ThinkPad E560 with Solid State Drive and Intel Core i5 processor) with Windows 7 and the local version of Office 2016 (NOT Office 365). I have noticed when using Excel 2016 that there is sometimes a long delay when using the buttons in the top ribbon to paste values or to change the fill color of a cell. Oddly, the delay does not happen when I do a regular paste and then use the drop-down menu that appears in the file immediately after the paste to select paste values--it is only when I use the paste values command underneath the paste button in the top ribbon. The delay varies in length, but sometimes seems as long as 30 seconds or more. During this time, Excel essentially freezes up and I am unable to do anything with any open Excel window. The delay eventually clears, the operation (whether pasting or changing cell fill color) completes, and I am able to use Excel normally again. At first I thought it had to do with the number of cells being affected, but this has happened with large and small cell ranges alike, so I don't think that is the issue. The problem is intermittent. Has anyone else seen something like this? Do I need to reinstall Office?
microsoft-excel microsoft-office microsoft-excel-2016 delay
asked Aug 6 '16 at 19:41
HaroldFinchHaroldFinch
913
You could try to reinstall office. You could make sure your drivers are up to date, such as graphic and chipset
– Dave
Aug 6 '16 at 20:25
1
Try disabling Hardware Acceleration in Display Settings in Excel 2016.
– patkim
Aug 6 '16 at 20:42
Agree with @pat2015 this is what happened to me and it fixed it. Could write it up too. With me if I recall, it actually was the same thing but in the older version of Excel with the "Paperclip Guy", but in fact it was the same issue of Hardware and/or Graphic Acceleration.
– ejbytes
Aug 7 '16 at 2:12
Still here? Can a Jeanie close this already?
– ejbytes
Apr 7 '17 at 6:19
add a comment |
I just bought a new computer (Lenovo ThinkPad E560 with Solid State Drive and Intel Core i5 processor) with Windows 7 and the local version of Office 2016 (NOT Office 365). I have noticed when using Excel 2016 that there is sometimes a long delay when using the buttons in the top ribbon to paste values or to change the fill color of a cell. Oddly, the delay does not happen when I do a regular paste and then use the drop-down menu that appears in the file immediately after the paste to select paste values--it is only when I use the paste values command underneath the paste button in the top ribbon. The delay varies in length, but sometimes seems as long as 30 seconds or more. During this time, Excel essentially freezes up and I am unable to do anything with any open Excel window. The delay eventually clears, the operation (whether pasting or changing cell fill color) completes, and I am able to use Excel normally again. At first I thought it had to do with the number of cells being affected, but this has happened with large and small cell ranges alike, so I don't think that is the issue. The problem is intermittent. Has anyone else seen something like this? Do I need to reinstall Office?
microsoft-excel microsoft-office microsoft-excel-2016 delay
asked Aug 6 '16 at 19:41
HaroldFinchHaroldFinch
913
I just bought a new computer (Lenovo ThinkPad E560 with Solid State Drive and Intel Core i5 processor) with Windows 7 and the local version of Office 2016 (NOT Office 365). I have noticed when using Excel 2016 that there is sometimes a long delay when using the buttons in the top ribbon to paste values or to change the fill color of a cell. Oddly, the delay does not happen when I do a regular paste and then use the drop-down menu that appears in the file immediately after the paste to select paste values--it is only when I use the paste values command underneath the paste button in the top ribbon. The delay varies in length, but sometimes seems as long as 30 seconds or more. During this time, Excel essentially freezes up and I am unable to do anything with any open Excel window. The delay eventually clears, the operation (whether pasting or changing cell fill color) completes, and I am able to use Excel normally again. At first I thought it had to do with the number of cells being affected, but this has happened with large and small cell ranges alike, so I don't think that is the issue. The problem is intermittent. Has anyone else seen something like this? Do I need to reinstall Office?
microsoft-excel microsoft-office microsoft-excel-2016 delay
microsoft-excel microsoft-office microsoft-excel-2016 delay
asked Aug 6 '16 at 19:41
HaroldFinchHaroldFinch
913
asked Aug 6 '16 at 19:41
HaroldFinchHaroldFinch
913
asked Aug 6 '16 at 19:41
HaroldFinchHaroldFinch
913
asked Aug 6 '16 at 19:41
HaroldFinchHaroldFinch
913
asked Aug 6 '16 at 19:41
HaroldFinchHaroldFinch
913
913
You could try to reinstall office. You could make sure your drivers are up to date, such as graphic and chipset
– Dave
Aug 6 '16 at 20:25
1
Try disabling Hardware Acceleration in Display Settings in Excel 2016.
– patkim
Aug 6 '16 at 20:42
Agree with @pat2015 this is what happened to me and it fixed it. Could write it up too. With me if I recall, it actually was the same thing but in the older version of Excel with the "Paperclip Guy", but in fact it was the same issue of Hardware and/or Graphic Acceleration.
– ejbytes
Aug 7 '16 at 2:12
Still here? Can a Jeanie close this already?
– ejbytes
Apr 7 '17 at 6:19
add a comment |
You could try to reinstall office. You could make sure your drivers are up to date, such as graphic and chipset
– Dave
Aug 6 '16 at 20:25
1
Try disabling Hardware Acceleration in Display Settings in Excel 2016.
– patkim
Aug 6 '16 at 20:42
Agree with @pat2015 this is what happened to me and it fixed it. Could write it up too. With me if I recall, it actually was the same thing but in the older version of Excel with the "Paperclip Guy", but in fact it was the same issue of Hardware and/or Graphic Acceleration.
– ejbytes
Aug 7 '16 at 2:12
Still here? Can a Jeanie close this already?
– ejbytes
Apr 7 '17 at 6:19
You could try to reinstall office. You could make sure your drivers are up to date, such as graphic and chipset
– Dave
Aug 6 '16 at 20:25
You could try to reinstall office. You could make sure your drivers are up to date, such as graphic and chipset
– Dave
Aug 6 '16 at 20:25
1
1
Try disabling Hardware Acceleration in Display Settings in Excel 2016.
– patkim
Aug 6 '16 at 20:42
Try disabling Hardware Acceleration in Display Settings in Excel 2016.
– patkim
Aug 6 '16 at 20:42
Agree with @pat2015 this is what happened to me and it fixed it. Could write it up too. With me if I recall, it actually was the same thing but in the older version of Excel with the "Paperclip Guy", but in fact it was the same issue of Hardware and/or Graphic Acceleration.
– ejbytes
Aug 7 '16 at 2:12
Agree with @pat2015 this is what happened to me and it fixed it. Could write it up too. With me if I recall, it actually was the same thing but in the older version of Excel with the "Paperclip Guy", but in fact it was the same issue of Hardware and/or Graphic Acceleration.
– ejbytes
Aug 7 '16 at 2:12
Still here? Can a Jeanie close this already?
– ejbytes
Apr 7 '17 at 6:19
Still here? Can a Jeanie close this already?
– ejbytes
Apr 7 '17 at 6:19
add a comment |
1 Answer
1
active
oldest
votes
Change your default printer to a document printer (like XPS). Most inexplicable Office hangs are because Office insists on being in continuous communication with its printer.
You can also attempt the answers that were provided in the comments section--disabling hardware acceleration can help.
answered Jan 19 '18 at 20:26
matt2103matt2103
113
While this sounds very weird I can confirm that this issue at least existed 18 years in the past and probably still does today. Old known bug in office.
– Hennes
Jan 22 at 0:21
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%2f1110622%2fhow-do-i-fix-a-long-delay-in-excel-2016%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
Change your default printer to a document printer (like XPS). Most inexplicable Office hangs are because Office insists on being in continuous communication with its printer.
You can also attempt the answers that were provided in the comments section--disabling hardware acceleration can help.
answered Jan 19 '18 at 20:26
matt2103matt2103
113
While this sounds very weird I can confirm that this issue at least existed 18 years in the past and probably still does today. Old known bug in office.
– Hennes
Jan 22 at 0:21
add a comment |
Change your default printer to a document printer (like XPS). Most inexplicable Office hangs are because Office insists on being in continuous communication with its printer.
You can also attempt the answers that were provided in the comments section--disabling hardware acceleration can help.
answered Jan 19 '18 at 20:26
matt2103matt2103
113
While this sounds very weird I can confirm that this issue at least existed 18 years in the past and probably still does today. Old known bug in office.
– Hennes
Jan 22 at 0:21
add a comment |
Change your default printer to a document printer (like XPS). Most inexplicable Office hangs are because Office insists on being in continuous communication with its printer.
You can also attempt the answers that were provided in the comments section--disabling hardware acceleration can help.
answered Jan 19 '18 at 20:26
matt2103matt2103
113
Change your default printer to a document printer (like XPS). Most inexplicable Office hangs are because Office insists on being in continuous communication with its printer.
You can also attempt the answers that were provided in the comments section--disabling hardware acceleration can help.
answered Jan 19 '18 at 20:26
matt2103matt2103
113
answered Jan 19 '18 at 20:26
matt2103matt2103
113
answered Jan 19 '18 at 20:26
matt2103matt2103
113
answered Jan 19 '18 at 20:26
matt2103matt2103
113
113
While this sounds very weird I can confirm that this issue at least existed 18 years in the past and probably still does today. Old known bug in office.
– Hennes
Jan 22 at 0:21
add a comment |
While this sounds very weird I can confirm that this issue at least existed 18 years in the past and probably still does today. Old known bug in office.
– Hennes
Jan 22 at 0:21
While this sounds very weird I can confirm that this issue at least existed 18 years in the past and probably still does today. Old known bug in office.
– Hennes
Jan 22 at 0:21
While this sounds very weird I can confirm that this issue at least existed 18 years in the past and probably still does today. Old known bug in office.
– Hennes
Jan 22 at 0:21
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%2f1110622%2fhow-do-i-fix-a-long-delay-in-excel-2016%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
You could try to reinstall office. You could make sure your drivers are up to date, such as graphic and chipset
– Dave
Aug 6 '16 at 20:25
1
Try disabling Hardware Acceleration in Display Settings in Excel 2016.
– patkim
Aug 6 '16 at 20:42
Agree with @pat2015 this is what happened to me and it fixed it. Could write it up too. With me if I recall, it actually was the same thing but in the older version of Excel with the "Paperclip Guy", but in fact it was the same issue of Hardware and/or Graphic Acceleration.
– ejbytes
Aug 7 '16 at 2:12
Still here? Can a Jeanie close this already?
– ejbytes
Apr 7 '17 at 6:19