Removing Bottlenecks

Removing Calculation Bottlenecks

 

Once you have identified the calculation bottlenecks you can use FastExcel to help you reduce or eliminate them:

Tune up your spreadsheet with FastExcel.

  1. Right-click on a cell containing a problem formula and access FastExcel’s built-in Help for advice on how to improve common bottlenecks.
  2. Use the Optimise Worksheet Sequence command to find improved worksheet calculation sequences.
  3. Access FastExcel’s advice on removing unnecessary calculations.
  4. Choose the best calculation options for your spreadsheet.
Right Click to access FastExcel contextual Help.

Right-Click on a cell or block of cells to access:

  • The Range calculation timer.
  • FastExcel’s built-in contextual Help.
  • On an ordinary Excel worksheet the contextual Help shows you the Optimise Calculations Help.
  • On a FastExcel output sheet the contextual Help shows you help for the nearest information block.
© 2001-2006 Decision Models  Legal Disclaimer Privacy Statement E-Mail Webmaster