{"id":2060,"date":"2021-07-05T05:23:59","date_gmt":"2021-07-05T05:23:59","guid":{"rendered":"https:\/\/anakage.com\/blog\/?p=2060"},"modified":"2024-03-27T12:14:01","modified_gmt":"2024-03-27T12:14:01","slug":"5-tips-to-speed-up-microsoft-excel","status":"publish","type":"post","link":"https:\/\/www.anakage.com\/blog\/5-tips-to-speed-up-microsoft-excel\/","title":{"rendered":"5 tips to speed up Microsoft Excel Performance"},"content":{"rendered":"\r\n<p><span>The feature-loaded Microsoft Excel is sometimes prone to issues like latency when opening a file, freezing, delayed response, and sometimes even &#8216;no response&#8217;. However, optimizing its performance is possible by disabling certain performance-robbing features like the used range, add-ins, automatic calculation, and graphic acceleration. In this article, we will explore some tips and tricks to enhance Microsoft Excel performance.<\/span><\/p>\r\n<p><img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/anakage.com\/blog\/wp-content\/uploads\/2021\/07\/How-to-Speed-Up-Microsoft-Excel-on-Your-Computer-632x356.png\" alt=\"How-to-Speed-Up-Microsoft-Excel-on-Your-Computer.\" width=\"632\" height=\"356\" class=\"size-medium wp-image-5796 aligncenter\" srcset=\"https:\/\/www.anakage.com\/blog\/wp-content\/uploads\/2021\/07\/How-to-Speed-Up-Microsoft-Excel-on-Your-Computer-632x356.png 632w, https:\/\/www.anakage.com\/blog\/wp-content\/uploads\/2021\/07\/How-to-Speed-Up-Microsoft-Excel-on-Your-Computer-1020x574.png 1020w, https:\/\/www.anakage.com\/blog\/wp-content\/uploads\/2021\/07\/How-to-Speed-Up-Microsoft-Excel-on-Your-Computer-768x432.png 768w, https:\/\/www.anakage.com\/blog\/wp-content\/uploads\/2021\/07\/How-to-Speed-Up-Microsoft-Excel-on-Your-Computer.png 1280w\" sizes=\"(max-width: 632px) 100vw, 632px\" \/><\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\">1. Try a Quick Repair\u00a0<\/h2>\r\n\r\n\r\n\r\n<p><span>Microsoft Excel offers a built-in automatic repair feature called &#8216;Open and Repair&#8217;, which can fix common issues. To run a quick repair:<\/span><\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Go to \u201cFile &gt; Open\u201d.<\/li>\r\n<li>Click on the small dropdown arrow in the \u2018Open\u2019 button.<\/li>\r\n<li>Choose \u2018Open and Repair\u2019\u00a0<\/li>\r\n<li>Click on the \u2018Repair\u2019 option\u00a0<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\">2. Remove Unused Add-ins\u00a0\u00a0\u00a0\u00a0<\/h2>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/WCN1jsaD_OIyqt1fKGak08aMIT6HvVcT-H4ri0kDXaPobZR3KhXsciCthM36e0hj-URVBpWbqZe5TCHHHJg8IeUVajtxRJzxaCCWHvMGngrEOKFjjiQZ3LnfXdQkQ5JIMk56JJnq\" width=\"624\" height=\"437\" \/>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/h2>\r\n\r\n\r\n\r\n<p><span>Add-ins like themes can burden your system and slow down your spreadsheets. To disable unnecessary add-ins:<\/span><\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Go to the \u2018File &gt; Options\u2019 menu and choose \u2018Add-ins\u2019 from the left sidebar.<\/li>\r\n<li>Click the \u2018Manage\u2019 dropdown, choose \u2018Excel Add-ins\u2019 and then choose \u2018Go\u2019.<\/li>\r\n<li>Uncheck all unnecessary items and click OK.\u00a0<\/li>\r\n<li>Close and reopen Microsoft Excel. Check whether Excel performs smoothly.<\/li>\r\n<li>If Excel is still slow, disable all items in \u2018COM Add-Ins\u2019, \u2018Actions\u2019 and \u2018XML Expansion Packs\u2019 and restart Excel.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\">3.\u00a0 Get Rid of Used Range\u00a0<\/h2>\r\n\r\n\r\n\r\n<p>Used range is the unused region on your worksheet that Excel thinks is being used. This can happen if you add and delete data from cells. If the used range is large, the size of your file will be larger than necessary, thus affecting the speed. Your workbook calculates more slowly than it should. Even navigating around the worksheets can be sluggish. To avoid this:<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Select the excess rows or columns on your worksheet.<\/li>\r\n<li>Choose the Excel Home &gt; Cells &gt; Delete Command (shortcut: ctrl+minus)<\/li>\r\n<li>Save the workbook as a new file.\u00a0<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\">4.\u00a0 Use Manual Calculation Mode\u00a0<\/h2>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/X39uHjL9gKoGZSUjWKYQULqeEdX9sM45-auttG0Pbz4AsH8OvDAkL8xSGCk6KGocqfNAGKAqaTRv0R_9BRgCo5ZxyDn3pgH6Kp-_vTBqswvvNvMmftXboAXdsVg9xxCqq47ofU9d\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p>When you update a value in a cell, Excel automatically recalculates the whole worksheet. You end up waiting for Excel to finish calculating, and this might delay your project. The solution to this issue is to set up Excel so that all computations are performed manually.\u00a0<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Go to File &gt; Options &gt; Formula.<\/li>\r\n<li>Under \u2018Workbook Calculation\u2019, look for \u2018Calculation Options\u2019. Find the \u2018Manual\u2019 button and click on it.<\/li>\r\n<li>Uncheck \u2018Recalculate Workbook Before Saving\u2019<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\">5.\u00a0 Disable Hardware Graphic Acceleration\u00a0<\/h2>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/tQDp6wAEg4NZVJbWsZz5VjeAEc7ETINYIDRpMr7HLv5pZraw6rRFywUPSaY8bqJWnrIyod4NtLd8WgKyj_H0MKunVjUT-5KS5JS82uec3iIuCpnydumZjLLEM3zkSoMX9ALecmfj\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p>While hardware graphics acceleration may sound like a performance boost, it actually refers to a slew of unnoticed animations that slow things down. To disable these features:<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Go to File &gt;Options&gt;Advanced<\/li>\r\n<li>Tick the Disable hardware graphics acceleration check box in the Display section of the Options window.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\">More Tips\u00a0<\/h2>\r\n\r\n\r\n\r\n<p><strong>1. Avoid Volatile Formulas: <\/strong>\u00a0Volatile formulas are recalculated every time when there is a change in the workbook. (For instance: NOW, RAND, OFFSET, etc.) So when there are a large number of volatile formulas, the entire formula set is recalculated. As a result, the worksheet gets sluggish.<\/p>\r\n\r\n\r\n\r\n<p><strong>2. Replace Unused Formulas by Static Values: <\/strong>A worksheet with a lot of formulas will be slow. If you have formulas that are no longer needed, you should change them to a static value by pasting them as values.\u00a0<\/p>\r\n\r\n\r\n\r\n<p><strong>3. Use Named Ranges: <\/strong>A named range is one or more cells that have been given a name. Using named ranges can make formulas easier to read and understand. Named ranges can assist speed up and improve accuracy. They can aid in the automation of updates to massive datasets and charts\/graphs.<\/p>\r\n\r\n\r\n\r\n<p><strong>4. Remove Conditional Formatting: <\/strong>\u00a0When you want to highlight cells that meet a specific criterion. It can slow down Excel when used on huge data sets or several times.<\/p>\r\n<p><span>By implementing these tips, you can significantly enhance <\/span><strong>Microsoft Excel performance<\/strong><span>.<\/span><a href=\"https:\/\/anakage.com\/blog\/category\/end-user-issues\/\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/anakage.com\/blog\/wp-content\/uploads\/2021\/07\/Blog-CTA-Priyanshu.png\" alt=\"https:\/\/anakage.com\/blog\/category\/end-user-issues\/\" width=\"1200\" height=\"400\" class=\"aligncenter wp-image-5795\" \/><\/a><\/p>\r\n\r\n\r\n\r\n<p>READ MORE:<\/p>\r\n\r\n\r\n\r\n<p><a href=\"https:\/\/anakage.com\/blog\/how-to-manage-environment-variables-in-windows\/\" target=\"_blank\" rel=\"noopener\">HOW TO MANAGE ENVIRONMENT VARIABLES IN WINDOWS?<\/a><\/p>\r\n\r\n\r\n\r\n<p><a href=\"https:\/\/anakage.com\/blog\/how-to-setup-time-zone-in-windows-system\/\" target=\"_blank\" rel=\"noopener\">HOW TO SETUP TIME ZONE IN WINDOWS?<\/a><\/p>\r\n\r\n\r\n\r\n<p><a href=\"https:\/\/anakage.com\/blog\/how-to-convert-a-word-file-to-pdf\/\" target=\"_blank\" rel=\"noopener\">HOW TO CONVERT A WORD FILE TO PDF?<\/a><\/p>\r\n\r\n\r\n\r\n<p><a href=\"https:\/\/anakage.com\/blog\/how-to-repair-corrupted-winzip-file\/\" target=\"_blank\" rel=\"noopener\">HOW TO REPAIR CORRUPTED WINZIP FILE?<\/a><\/p>\r\n\r\n\r\n\r\n<p><a href=\"https:\/\/anakage.com\/blog\/\/how-to-resolve-broken-images-in-the-e-mail-body\/\" target=\"_blank\" rel=\"noopener\">HOW TO RESOLVE BROKEN IMAGES IN EMAIL BODY ?<\/a><\/p>\r\n\r\n\r\n\r\n<p><a href=\"https:\/\/anakage.com\/blog\/how-account-lockouts-for-various-credentials-can-be-resolved\/\" target=\"_blank\" rel=\"noopener\">HOW ACCOUNT LOCKOUTS FOR VARIOUS CREDENTIALS CAN BE RESOLVED<\/a><\/p>\r\n\r\n\r\n\r\n<p><a href=\"https:\/\/anakage.com\/blog\/how-to-use-disk-cleanup\/\" target=\"_blank\" rel=\"noopener\">HOW TO USE DISK CLEANUP ?<\/a><\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>The feature-loaded Microsoft Excel is sometimes prone to issues like latency when opening a file, freezing, delayed response, and sometimes [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":5796,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_themeisle_gutenberg_block_has_review":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"coauthors":[88],"class_list":["post-2060","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"views":1213,"jetpack_featured_media_url":"https:\/\/www.anakage.com\/blog\/wp-content\/uploads\/2021\/07\/How-to-Speed-Up-Microsoft-Excel-on-Your-Computer.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.anakage.com\/blog\/wp-json\/wp\/v2\/posts\/2060","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.anakage.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.anakage.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.anakage.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.anakage.com\/blog\/wp-json\/wp\/v2\/comments?post=2060"}],"version-history":[{"count":0,"href":"https:\/\/www.anakage.com\/blog\/wp-json\/wp\/v2\/posts\/2060\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.anakage.com\/blog\/wp-json\/wp\/v2\/media\/5796"}],"wp:attachment":[{"href":"https:\/\/www.anakage.com\/blog\/wp-json\/wp\/v2\/media?parent=2060"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.anakage.com\/blog\/wp-json\/wp\/v2\/categories?post=2060"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.anakage.com\/blog\/wp-json\/wp\/v2\/tags?post=2060"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.anakage.com\/blog\/wp-json\/wp\/v2\/coauthors?post=2060"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}