FastExcel Toolbar

The Calculate and Time commands show you the time taken to do the calculation.

Calculate Range, Calculate Selected Sheets, Recalculate Workbooks, Full Calculate Workbooks.

The Profiling commands allow you to find calculation bottle-necks and memory usage.

Profile Workbook, Optimise Worksheet Sequence & Profile Worksheet Areas.

The Calculation Options button is a shortcut to Excel’s calculation options form.

 
Calculation Options & Disable/Enable Sheet Calculation.

The Memory commands allow you to see how much Excel memory is being used.

Memory Used  & Pivot Cache Memory Used.

The FastExcel dropdown on the toolbar gives you access to Help on both FastExcel itself, and how to optimise Excel formulae for faster calculation.

FastExcel Help provides help on the use of FastExcel.
Optimise Calculations Help contains advice on making Excel calculate faster.
About FastExcel shows you the currently loaded version and build number.

Both Excel and Windows try to optimise performance by storing recent information in memory. So Excel’s second full Calculate is often significantly faster than the first.
Excel also saves some of this information with the Workbook.

Sometimes you will find that your FastExcel timing results are not completely repeatable, even though FastExcel measures elapsed time using a high-resolution timer capable of timing intervals in Microseconds.

Both Excel and Windows cache information to speed up subsequent operations.

Windows is a multitasking system so Excel does not get the whole system to itself.

Windows is a multitasking, paged virtual memory operating system so other system tasks are always running at the same time as Excel. Try and make sure there are no other user tasks active whilst you are using FastExcel

Excel’s background calculation process can easily be interrupted.

Excel’s background calculation process can be interrupted if you press any key or click the mouse whilst FastExcel is active. This may give you inaccurate timings.