Saturday, April 13, 2013

How to Speed Up Excel 2007 Calculations


1. Open Excel. Click on the 'Formulas' tab at the top of the spreadsheet, which is between 'Page Layout' and 'Data.' Click on the 'Calculation Options' button that appears to the right; a drop-down menu appears. You will see that the 'Automatic' option is checked.
2. Select the 'Manual' option from the drop-down menu in order to disable automatic recalculations of all cells whenever a change is made to one. Now Excel will only recalculate when you explicitly tell it to do so. Alternatively, you may choose the option 'Automatic Except for Data Tables,' which will automatically make changes to all cells that are directly affected by a cell change except for those in data tables. This will prove faster than the 'Automatic' option, but slower than the 'Manual' option.
3. Click on the 'Options' button at the very top of Excel. From the drop-down menu, select the 'Excel Options' button at the very bottom. A new menu appears. Hit the button called 'Formulas.' More options appear to the right. Under the heading 'Calculation Options,' you will see that 'Automatic' is checked again. Click the 'Manual' bubble in order to enable this feature for Excel more generally. Another box that says 'Recalculate workbook before saving' is also checked. Uncheck this box so that Excel does not automatically calculate every time you save.
4. Go back to the 'Excel Options' menu and select 'Advanced.' From here, go to 'Formulas' and then look for an option called 'Enable multi-threaded calculations.' Check this box and then adjust the number of processors that you want your computer to dedicate to performing Excel calculations. More processors will increase the speed at which Excel calculates. Note that increasing this number will slow down other applications that your computer is running.

Blogger news