-->![To Speed Up The Process To Speed Up The Process](/uploads/1/3/7/2/137276357/866197260.jpg)
![Formal Formal](/uploads/1/3/7/2/137276357/133407147.png)
13 Methods of How to Speed Up Excel Excel is fast enough to calculate 6.6 million formulas in 1 second in Ideal conditions with normal configuration PC. But sometimes we observe excel files doing calculation slower than snails. Some states turn to retired medical professionals to speed up vaccination process. In the quest to ramp up COVID-19 vaccine distribution, some states are turning to retirees.
- With Covid-19 vaccinations being rolled out around the world, here are three proposals by architects to speed up the process including drive-through facilities, shipping-container clinics and pods.
- Synonyms for speed up include accelerate, go faster, increase speed, move faster, drive faster, gather speed, gain momentum, get faster, hurry up and pick up speed. Find more similar words at wordhippo.com!
- No matter how good you are about keeping your computer clean and up-to-date, they tend to slow down after time. Fortunately, there are a lot of ways to help speed them up― without upgrading your hardware. If you use more than one antivirus or antispyware program at the same time, your device may.
No matter how good you are about keeping your computer clean and up-to-date, they tend to slow down after time. Fortunately, there are a lot of ways to help speed them up― without upgrading your hardware.
Original product version: Windows 7 Service Pack 1
Original KB number: 3064207
Original KB number: 3064207
Note
If you are an advanced user, you can download a free tool from the Microsoft website that shows you all of the programs and processes that run when you start Windows, including the ones that Windows requires to operate successfully. Use this tool only if you are comfortable restoring Windows after an error occurs.
Uninstall extra antivirus programs
If you use more than one antivirus or antispyware program at the same time, your device may experience decreased performance, become unstable, or restart unexpectedly. To remedy the issue, you should select one Internet security program to run on your device. You should then uninstall the other programs.
Caution
Make sure you have an Internet security program running on your device before you uninstall other security programs.
Some Internet security applications do not uninstall completely. You may need to download and run a cleanup utility for your previous security application to completely remove it.
If you use another antispyware program together with Microsoft Security Essentials, we recommend that you turn off real-time scanning in the other program. For more information, see the documentation supplied by that antispyware program.
To remove an antivirus or antispyware program, follow these instructions:
- Swipe in from the right edge of the screen (if using a mouse, point to the upper-right corner of the screen and move the mouse pointer down).
- Tap or select Search.
- Type appwiz.cpl in the Search box.
- Tap or select Appwiz.cpl on the left side of your screen.
- In the list of installed programs, uninstall the Internet security programs you don't need.
- Restart your device.
Close programs in the notification area running with startup
If your device takes a long time to start up, one of the causes could be having a large number of startup apps or a few apps that have a high impact on startup time.
Some of these programs add an icon to the notification area on the taskbar to show that they are running with startup.
To stop a program that has one of these icons from automatically running on startup, follow these instructions:
- On the Start screen, tap or select Desktop image to see the icon tray.
- Point to each icon to see the program name.
- To ensure that you can see icons for all running programs, tap or select Show hidden icons.
- Open a program that you do not want to run on startup. In the options for that program, find a setting similar to Run at startup. Set the option to Off or No.
Note
You must open any program that you do not want to run on startup and change the setting.
View Startup items
To see what programs run at startup and disable any, follow these instructions:
- Press and hold or right-click in the blank area on Taskbar and select Task Manager.
- Tap or select More details in the lower-left corner of Task Manager.
- Under the Startup tab in Task Manager, you can view a list of applications that start automatically every time you turn on your device and sign in to Windows.
- If you see any programs in this list that you do not want to run when Windows starts, tap or select the application and then tap or select Disable.
Note
Disabling a program from running at startup doesn't stop the program from running if you need it. If you tap or select the program after startup, it will start and run normally.
Change a program
Sometimes, by adding or removing certain program options, you can prevent a program from running at startup.
If you can't stop the program from running on startup and the program does not have the option to change the configuration, you must talk to the program manufacturer for a solution.
To change the configuration of a program, follow these instructions:
- Swipe in from the right edge of the screen (if using a mouse, point to the upper-right corner of the screen and move the mouse pointer down).
- Tap or select Search.
- Type appwiz.cpl in the Search box.
- Tap or select Apps.
- Tap or select Appwiz.cpl on the left side of your screen.
- Tap or select a program, and then tap or select Uninstall, Change, or Repair.
If prompted, type an administrator password or confirmation.
Clean up disk errors
Over time, your device may create errors on its hard drive. These errors can slow your device. The Check Disk program identifies and cleans any errors.
To run Check Disk, follow these instructions:
- Swipe in from the right edge of the screen (if using a mouse, point to the upper-right corner of the screen and move the mouse pointer down).
- Tap or select Search.
- Type computer in the Search box.
- Tap or select Apps.
- Tap or select Computer on the left side of your screen.
- Press and hold or right-click the drive you want to repair, and then tap or select Properties.
- Tap or select the Tools tab.
- Under Error checking, tap or select Check. Depending upon the size of your hard disk, this may take several minutes. For best results, don't use your device for any other tasks while it's checking for errors. If prompted, type an administrator password or confirmation.
- You may need to restart your device after error checking is complete.
Defragment your hard disk
One of the best ways to help improve your device's performance is by optimizing the hard drive. Optimize Drives, previously known as Disk Defragmenter, is a Windows feature that helps optimize different types of drives. The feature runs automatically on a weekly schedule, but you can also run Optimize Drives manually.
To run Optimize Drives manually, follow these instructions:
- Swipe in from the right edge of the screen (if using a mouse, point to the upper-right corner of the screen and move the mouse pointer down).
- Tap or select Search.
- Type computer in the Search box.
- Tap or select Apps.
- Tap or select Computer on the left side of your screen.
- Press and hold or right-click the drive you want to repair, and then tap or select Properties.
- Tap or select the Tools tab.
- Tap or select Optimize under Optimize and defragment drive.
- Under Status, tap or select the drive you want to optimize. (The Media type column tells you what type of drive you're optimizing.)
- To determine if the drive needs to be optimized, tap or select Analyze. Note: If prompted, type an administrator password or confirmation.
- After Windows finishes analyzing the drive, check the Current status column to see whether you need to optimize the drive. If the drive is more than 10 percent fragmented, you should optimize it.
- Tap or select Optimize.
Note
![To Speed Up The Process To Speed Up The Process](/uploads/1/3/7/2/137276357/866197260.jpg)
- Optimizing a drive can take anywhere from several minutes to several hours to finish, depending on the size of the drive and degree of optimization required. You can still use your device during the optimization process.
- If the drive is being used by another program or is formatted using a file system other than NTFS, FAT, or FAT32, it can't be optimized.
- Network drives can't be optimized.
- If a drive doesn't appear in Optimize Drives, it might be because it contains an error. Try to repair the drive first, then return to Optimize Drives to try again.
To change the optimization schedule, follow these instructions:
- Swipe in from the right edge of the screen (if using a mouse, point to the upper-right corner of the screen and move the mouse pointer down).
- Tap or select Search.
- Type computer in the Search box.
- Tap or select Apps.
- Tap or select Computer on the left side of your screen.
- Press and hold or right-click the drive you want to repair, and then tap or select Properties.
- Tap or select the Tools tab.
- Tap or select Optimize under Optimize and defragment drive.
- Tap or select Change settings. If prompted, type an administrator password or confirmation.
- Select one of the following:
- To turn off scheduled optimization, clear the Run on a schedule check box.
- To change the frequency of scheduled optimization, tap or select the drop-down list next to Frequency, and then tap or select Daily, Weekly, or Monthly. The default schedule for optimization is weekly and runs during Automatic Maintenance.
- To select the drives you want to include or exclude in scheduled optimization, tap or select Choose next to Drives. Select or clear the check boxes next to the drives and then tap or select OK. You can also clear the Automatically optimize new drives check box if you don't want new drives added to scheduled optimization. If Windows can't optimize a drive, it won't offer the drive as an option for Automatic Maintenance.
- Tap or select OK.
Clean your hard disk
Disk Cleanup reduces the number of unnecessary files on your drives by deleting temporary files and system files, emptying the Recycle Bin, and removing a variety of other items that you may no longer need.
To clean your hard disk, follow these instructions:
- Swipe in from the right edge of the screen (if using a mouse, point to the upper-right corner of the screen and move the mouse pointer down).
- Tap or select Search.
- Type free up disk space in the Search box.
- Tap or select Settings.
- Tap or select Free up disk space by deleting unnecessary files on the left side of your screen.
- In the Drives list, tap or select the drive that you want to clean up.
- Tap or select OK.
- In the message that appears, tap or select Delete files.
To clean up system files associated with your account, follow these instructions:
- In the Drives list, tap or select the drive that you want to clean up and then tap or select OK.
- In the Disk Cleanup dialog box, tap or select Clean up system files. Note: If prompted, type an administrator password or confirmation.
- The More Options tab is available when you opt to clean up system files from your device. This tab includes two additional options for freeing up space:
- Programs and Features. This option opens Programs and Features in Control Panel, where you can uninstall programs that you no longer use. The Size column in Programs and Features shows how much space each program uses.
- System Restore and Shadow Copies. System Restore uses restore points to return your system files to an earlier point in time. If your device is running normally, you can save space by deleting earlier restore points.
Turn off visual effects
If Windows is running slowly, you can speed it up by disabling certain visual effects. You can select which visual effects to turn off one by one or you can let Windows select for you.
To turn off visual effects, follow these instructions:
- Swipe in from the right edge of the screen (if using a mouse, point to the upper-right corner of the screen and move the mouse pointer down).
- Tap or select Search.
- Type Performance Information and Tools in the Search box.
- Tap or select Settings.
- Tap or select Performance Information and Tools on the left side of your screen.
- Tap or select Adjust visual effects. If prompted, type an administrator password or confirmation.
- Under Visual Effects tab, check on Adjust for best performance, and then tap or select OK. (For a less drastic option, select Let Windows choose what's best for my computer.
Run fewer programs at the same time
Sometimes you can improve system performance by changing your computing behavior. Running four or more programs while leaving multiple browser windows and email messages open may be more than your device can handle.
If you find your device slowing down, decide whether you really need to keep all of your programs and windows open at the same time. Also, find a way to remind yourself to reply to email messages later instead of keeping them open until you reply.
Use ReadyBoost
ReadyBoost can speed up your device by using storage space on flash memory cards and USB flash drives. If you have a storage device that will work with ReadyBoost, you'll see an option to use ReadyBoost when you plug it into your device. If you select this option, you can select how much memory to use.
Adjust indexing options
Windows uses an index to perform very fast searches of the most common files on your device. If it's taking too long to search for things on your device, you can narrow your search to focus on the files and folders that you most commonly use.
Adjust power plan
A power plan is a collection of hardware and system settings (such as display, sleep, and so on) that manages how your device uses power. The power plans you can use depend on the kind of device you have.
Excel is fast enough to calculate 6.6 million formulas in 1 second in Ideal conditions with normal configuration PC. But sometimes we observe excel files doing calculation slower than snails. There are many reasons behind this slower performance. If we can Identify them, we can make our formulas calculate faster. In this article, we will learn how can we make our excel files calculate faster.
These are the methods that can make your excel calculate faster.
1 : Reduce the complexity and number of formulas
I know I said that excel can calculate 6.6 million formulas in one second. But in Ideal conditions. Your computer is not only using Excel program right. It has other tasks running.
Excel does not only have formulas. It has data, tables, charts, add inns, etc. All these increase the burden on the processor. And when you have thousands of complex formulas running, it slows down the processor.
So, if it is possible, reduce the number of the formulas and complexity of formulas.
![Formal Formal](/uploads/1/3/7/2/137276357/133407147.png)
2. Use all the processors available for Excel.
Some times your computer is busy in processing other threads. Making all the processors available for excel will increase the speed of Excel significantly. To do so follow these steps:
Go to file --> Options --> Advanced. Here scroll down and find Formulas Section. Select the 'Use all the processors in this computer: 4'. This will allow excel to use all the processors available on the system. It will make the calculations fast.
Now excel calculating using 4 processors on my system. It can be more or less on your system.
3: Avoid use of Volatile Functions
The volatile functions like NOW(), OFFSET(), RAND(), etc. recalculate every-time a change is made in Excel file. This increases the burden on the processors. When you have a large number of formulas in the workbook and you make any change in the excel file, the whole file starts to recalculate, even if you don't want it. This can take too much time and even make Excel crash. So if you have a large number of formulas in the excel file make sure they are not volatile functions.
Some commonly used volatile functions are, OFFSET, RAND, NOW, TODAY, RANDBETWEEN, INDIRECT, INFO, CELL.
4: Switch to Manual Calculation in Excel
If you got have large number of complex formulas with or without volatile functions, set the workbook calculation to manual.
This does not mean that you have to do manual calculations. It just mean that you will tell excel when to recalculate the workbook.
By default, Excel is set to automatic calculations. Due to automatic calculations you can see the change in result of a formula when you change the source data, instantly. This slows the Excel speed.
But if you use manual calculation, the change will not reflect instantly. Once you have done all the task in the sheet, you can use F9 key to tell excel to recalculate the workbook. This will save a lot of resource and time.
To switch to manual calculations, go to File --> Options --> Formulas. You will have a number of options available. Find calculation option and select the manual calculation and hit the OK button.
5: Do not use Data Tables for Large Data Set
The data tables give a lot functionality that is really helpful. But these functionalities are costly in terms of resources. If you have a large set data than you should avoid using excel data tables. They use a lot of computer resources and can slow down the performance of Excel file. So, if it is not necessary, avoid using Data table for faster calculation of formulas. This will increase formula calculation speed.
6: Replace the Static Formulas with Values:
If you have a large set of calculations and some of the formulas does not change the results, it is better to replace the with values. For example, if you are using VLOOKUP function to import or merge tables for one time, it is better to replace the formula with values.
To do so, copy the result range. Right-Click on the range and go to paste special. Here select Value and hit the OK button. You can read about pasting value here.
7: Disabling the Excel Add ins
The Excel add ins are additional functionalities we add to the tool. They may not needed every time. If you can disable them, you can save a lot of resource on your system. This will help you increase the formula calculation speed.
To disable the add ins go to File --> Options --> Add Ins. Select the add ins and click on Go button.
This will open the add active add ins. Uncheck the add ins that you don't need. Hit OK button.
This will disable the add ins.
8: Avoid Unnecessary Conditional Formatting in workbook.
The conditional formatting takes a lot of calculation time so it is better to only use them where it is necessary. Do not use the conditional formatting the large data set.
9: Remove unnecessary pivot tables
The pivot tables are great tool for quickly summarizing a large set of data. But if you need the pivot table only for one time, use and delete them. You can keep the value pasted pivot report. If you want to have dynamic data, use formulas.
10: Replace Formulas with VBA Macros
There's nothing you can't do using Macros. Sometime it is even more handy and easy to do calculations in VBA than directly on worksheet. You can use the worksheetfunctions object to access the worksheet function VBA. Use them to do large number of calculation and paste value using VBA. This will increase the speed of Excel calculations exponentially.
11: Delete Unused Ranges and Sheets
It is common to use the spare sheets and ranges while working. But you might not know that excel remembers in which ranges you have worked and keeps it into used ranges memory. It is smart delete such sheets and ranges from workbook, so that excel does not uses them any more.
12: Save Excel File as Excel Binary File
If your excel file does not requires to interact with other tools than you should save the excel file as Excel Binary File. The extension of an Excel binary file is .xlsb. This does removes any functionality from excel. Your file just won't be able to interact with other tools.
13: Consider Using Database tools for storing data.
Most of the time Excel formula calculations slows down due to large amount of data in the workbook. So if you can save the source data in some other database tool or CSV file and use excel for only calculation than you can increase the speed of formula calculations. You can use power pivot or power query to import data temporarily for analyzing data.
So yeah guys, these are the ways to increase the speed of formula calculation in Excel. If you do all these things you will surely increase the calculation speed and excel will not stop or crash while performing calculations.
I hope it was explanatory and helpful. If you have any doubt or special scenario, please let me know in the comments section below. I will be happy to hear from you. Till than keep Excelling.
Related Articles:
Center Excel Sheet Horizontally and Vertically on Excel Page : Microsoft Excel allows you to align worksheet on a page, you can change margins, specify custom margins, or center the worksheet horizontally or vertically on the page. Page margins are the blank spaces between the worksheet data and the edges of the printed page
Split a Cell Diagonally in Microsoft Excel 2016 : To split cells diagonally we use the cell formatting and insert a diagonally dividing line into the cell. This separates the cells diagonally visually.
How do I Insert a Check Mark in Excel 2016 : To insert a checkmark in Excel Cell we use the symbols in Excel. Set the fonts to wingdings and use the formula Char(252) to get the symbol of a check mark.
How to disable Scroll Lock in Excel : Arrow keys in excel move your cell up, down, Left & Right. But this feature is only applicable when Scroll Lock in Excel is disabled.
How To Speed Up The Process Of A Divorce
Scroll Lock in Excel is used to scroll up, down, left & right your worksheet not the cell. So this article will help you how to check scroll lock status and how to disable it?
How To Speed Up The Process Of Tattoo Removal
What to do If Excel Break Links Not Working : When we work with several excel files and use formula to get the work done, we intentionally or unintentionally create links between different files. Normal formula links can be easily broken by using break links option.
Popular Articles:
To Speed Up The Process
50 Excel Shortcuts to Increase Your Productivity | Get faster at your task. These 50 shortcuts will make you work even faster on Excel.
How to use Excel VLOOKUP Function| This is one of the most used and popular functions of excel that is used to lookup value from different ranges and sheets.
To Speed Up The Process Italiano
How to use theExcel COUNTIF Function| Count values with conditions using this amazing function. You don't need to filter your data to count specific value. Countif function is essential to prepare your dashboard.
Sample Letter To Speed Up The Process
How to Use SUMIF Function in Excel | This is another dashboard essential function. This helps you sum up values on specific conditions.