You can force a full calculation of all the formulas by pressing CTRL ALT F9, or you can force a complete rebuild of the dependencies and a full calculation by pressing SHIFT CTRL ALT F9.Excel formulas that reference other cells can be put before or after the referenced cells (forward referencing or backward referencing).If you work with large workbooks, you probably have found that the increased memory capacity of recent versions of Excel has meant that you hit some of the other Excel specification limits more frequently.Excel 2007 includes many changes to these limits to accompany the large increase in row and column capacity.
Studies have shown that a user's productivity and ability to focus on a task deteriorate as response time lengthens.
Summary: Learn about the increased worksheet capacity in Microsoft Office Excel 2007 and techniques that you can use as you design and create worksheets to improve calculation performance.
(40 printed pages)The "Big Grid" of 1 million rows and 16,000 columns in Microsoft Office Excel 2007, along with many other limit increases, substantially increases the size of worksheets that you can build compared to earlier versions of Excel.
This article is based on experience with the Beta 2 version of Microsoft Office Excel 2007 and therefore may not accurately reflect the content, user-interface, or performance of the final version of Excel 2007.
The Excel 2007 "Big Grid" increases the maximum number of rows per worksheet from 65,536 to over 1 million, and the number of columns from 256 (IV) to 16,384 (XFD).
For calculation times greater than 10 seconds, users become impatient and usually switch to other tasks while waiting.