FastExcel V4 Profile Formulas

FastExcel V4 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 V4.
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 formulas and functions. Volatile and single-threaded formulas can be a major reason for slow calculation.

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

Try it out for yourself:

Download FastExcel V4.

Get a 15-day full-featured trial license

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

Want to know more?

View the FastExcel V4 WebHelp

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