Excel.Tips.Net: Speeding Up Large Excel Worksheets

By Allen Wyatt for Excel.Tips.Net

Excel users are always looking for ways to speed up large worksheets. If you are using a large worksheet that has lots of static formulas in it, this tip may be of help to you.

Consider the following scenario: You have a large spreadsheet with many hundreds of rows. Each row has a couple of data columns and then a column or two that perform calculations on those data columns. Once the data columns are set, the information in the calculated columns never changes. However, Excel must still perform the calculations every time it goes through a recalculation cycle.

Article Continued Here

This post is excerpted with permission from Excel.Tips.Net

Subscribe to the Free ExcelTips Newsletter with the links below

(for those using Excel 97 through 2003)

(for those using Excel 2007 through 2010)

(Visited 24 times, 1 visits today)

One thought on “Excel.Tips.Net: Speeding Up Large Excel Worksheets

Leave a Reply

Your email address will not be published. Required fields are marked *