FastExcel V3 Profile Formulas

FastExcel V3 Profile Formulas - detailed profiling of the formulas on a worksheet

The ability to directly profile formulas and functions is one of the major advances in FastExcel V3.
Profile formulas provides a detailed and prioritised analysis of each unique formula and function used on the worksheet.

Profile Formulas Options

Profile Formulas Output

The output shows how long each formula takes to calculate, and what is the percentage of the total time used by all the occurrences of the formula.

The flags identify the characteristics of the formula. Volatile and single-threaded formulas can be a major reason for slow calculation.

  • A - This is an Array formula
  • B - This formula contains a Built-in, native Excel function
  • X - This formula contains a registered XLL function
  • O - This formula contains a VBA, Automation, or XLM function
  • N - This formula is not Volatile
  • V - This formula is Volatile
  • ? - Cannot tell if this formula is Volatile or not
  • M - This formula is Multi-threaded
  • S - This formula is probably Single-threaded

Try it for yourself!

Download the 15-day full-featured trial of FastExcel V3 build 232.656.791.380

Note: the trial version of FastExcel V3 profiler does not enable Profile Workbook, Profile Worksheet and Profile Formulas, and the Drill down wizard will only profile a single worksheet.

You can convert the trial version of FastExcel V3 to a fully licensed version at any time by purchasing one of the FastExcel V3 licensing options.

Want to know more?

Download the FastExcel V3 Help file or the FastExcel V3 User Guide (PDF)
(you may need to unblock the downloaded .CHM file - Right-Click->Properties->Unblock)

See Whats New for changes in this build

© 2001-2014 Decision Models  Legal Disclaimer Privacy Statement E-Mail Webmaster