Trying to get some work done but Excel is running slowly? There are a number of ways that you can speed up your spreadsheets in order to get more work done in a short period of time. After all, the whole point of using Excel and similar software is to get things done quickly and with accuracy.
Simple Tips to Speed up Excel
- Close other programs.
This tip is kind of a no-brainer, and you probably apply it to other software too. Closing non-essential programs always seems to help speed up the essential ones. If you’re trying to get work done quickly, close that internet browser along with any other applications running in the background.
- Use 64bit Excel
While Microsoft’s recommendation is that we use 32bit Excel, we prefer 64bit for faster calculations. Of course in order for you to use the 64bit version, your computer has to support 64bit software. The reason Microsoft recommends that we use 32bit Excel, in case you’re wondering, is that it supports more add-ins.
- Disable add-ons
Disabling add-ins ties with our previous point. In order to get faster calculations you should try disabling add-ons that are potentially slowing down the software. That’s why we don’t care about the benefits that come with 32bit Excel. We don’t want them anyway since they slow us down.
- Switch your computer’s region to English USA
Your computer’s selected region can have an impact on its speed. Switching it to English (USA) can speed up calculation time by as much as 80%. Sadly, if your region is already set at English (USA) then this won’t be useful for you.
- Avoid volatile formulas
Volatile formulas are those that are recalculated every time a change is made in your workbook. Here are some examples of volatile formulas: NOW, TODAY, INDIRECT, OFFSET, RAND, INFO, CELL. INDIRECT and OFFSET in particular can significantly slow down your Excel workbook so consider replacing them with others.
- Avoid data tables
Data tables are useful tools and you won’t like what we have to say about them. The truth is that they have a big impact on calculation time. If you really can’t live without them then you can try switching the calculate mode to “automatic except for data tables.” That way you’ll keep using them but they’ll stop slowing down your Excel workbook and spreadsheets.
- Optimize your computer
If your computer is running in optimal condition, this should reflect on the apps you use. In order to optimize your computer running on Windows 7, go to control panel, “system,” and then “advanced system settings.”
On the “advanced” tab click on settings then on “adjust for best performance.” This should speed up your computer in general and not just when it comes to Microsoft Excel.
Microsoft Excel is one of the most useful apps not just in business, but also in life. They can be used to help us with almost anything. There’s no reason we have to settle for lagging software though so hopefully these few tips can help you speed up your MS Excel workbook.