XL: Optimizing Worksheets for Fastest Calculation

ID: Q72622


The information in this article applies to:


SUMMARY

In Microsoft Excel, recalculation performance is affected by the way data and formulas are arranged on the worksheet. The following list contains tips for optimizing your worksheet to improve recalculation speed:


REFERENCES

"User's Guide," version 5.0, pages 166-170
"User's Guide 1," version 4.0, pages 167-174
"User's Guide," version 3.0, pages 294-300, 697-700

Additional query words: 3.00 4.00 4.00a recalc calc


Keywords          : 
Version           : WINDOWS:3.x,4.x,5.0,5.0c,7.0,97
Platform          : 
Issue type        : 

Last Reviewed: March 21, 1999