The Profiling Header

Navigation: FXLV4Profiler > FastExcel Calculation Profiler >

All five profiling commands document the profiled workbook by showing a common set of header tables:

The Physical Environment Table

Cells with red dots contain on-sheet Notes: hover your cursor to make them pop-up.

The Physical Environment Table shows information about the system.

Orange if Memory Used>1MB and (Memory Used +64)>RAM (MB)

RAM (MB): Physical Memory Used and installed in megabytes. You should have at least enough physical memory installed for Windows, Excel and all the open workbooks. See Bottlenecks.

Swap File (MB): Swap File used and Swap file available in megabytes. If your system is using a large amount of your existing swap file either close as many programs as possible or increase the size of your swap file.

Excel Memory (MB): Excel Memory Used and available. Total Memory Used by all open Excel workbooks for data, formulas etc. (excludes Memory Used by the Excel program itself), and the maximum Excel workbook memory available for formulas etc. Megabytes.

Orange if Used/Available > 3.75 * Orange Tolerance

Orange if Used/Available> 3.75*Orange Tolerance

File Size (K): The size on disk of the workbook in Kilobytes.

Operating System: The version of OS in use when this profile was created.

MHZ x Cores: The processor speed in MHZ, and the number of processor cores in the system.

XLVersion: the Excel version number and bitness used for this profile:

Excel 97 is Version 8

Excel 2000 is Version 9

Excel 2002 is Version 10

Excel 2003 is Version 11

Excel 2007 is Version 12

Excel 2010 is Version 14

Excel 2013 is Version 15

Excel 2016 is version 16

XL Calculation Engine: The version number of the calculation engine that was used for this profile. If not Excel 2000 or a later version, N/A.

The Workbook Settings Table.

The Workbook Settings Table shows basic information on the profiled workbook:

The name and path of the profiled workbook and the date and time that the profile was created. (Not shown in the above picture)

If Shared and Keep Change History are both true they are colored orange.

Shared: True if the Workbook is open for Sharing. If Shared and Keep Change History are both true the Workbook size can grow considerably.

Changes: Keep Change History Tracking: True if enabled, otherwise False. If Shared and Keep Change History are both true the Workbook size can grow considerably.

Saved: False if the workbook has been changed in any way since the last save.

Avoid saving in Dual Format

Format: the format of the saved workbook: Dual Format (Orange) doubles the file size.

Fixed: Fixed Decimal: If True numbers will be treated as having an implied decimal point, in the position given by Places below.

Places: The position of the implied decimal point, if Fixed Decimal is true.

Backup: True if a backup copy of the workbook will be created when you save.

Styles: The number of Styles in the workbook. If this number is large you may want to use Clean Workbook to map where the styles are being used, and to remove unused styles.

Protection: The following three items show the protection status of the Workbook structure and windows, and whether the book is password protected.

Colored orange if true

Structure: True if the structure of the workbook is protected. If protected with a password then opening the workbook will be slow.

Worksheets: True if the worksheets in the workbook are protected.

Password: True if the workbook is Password protected.

Views: The number of Views in the workbook.

The Environment Counts Table

Colored orange if >100

XLB/Qat (K): The size of the XLB and QAT files in K Bytes. The XLB file stores toolbar customizations. The QAT file stores ribbon customizations.
When they get large, they may become corrupted and cause memory problems.
The XLB file is located in %AppData%\Microsoft\Excel and the QAT file is located in %LocalAppData%\Microsoft\Office\

COM Addins: The number of COM addins currently loaded

Temp: Count of the temporary files in your Windows temporary directory and subfolders. A large number of Temp files may make your workbook slow to open or cause Excel to crash. The Clean Workbook command can delete all temporary files that are not currently being used.

Note: a very large number of temp files may cause FastExcel to hang with the status bar showing “Checking Temp Files”. If this occurs close Excel, reboot your PC and then delete all files in your temp folder. You can locate your temp folder using StartRun, entering %temp% in the run box and pressing enter.

VBE: Total Number of Windows in use by the VBE IDE. Includes hidden windows. A large number of open VBE Windows consumes resources and may cause memory problems. (If blank in Excel 2002 or later check "Allow access to Visual Basic Project" in Tools, Macros, and Security). The Clean Workbook command can close all unnecessary VBE Windows.

Colored orange if >15

Addins: The number of Excel Add-Ins currently loaded by Excel’s Addin Manager. This excludes any addins that have been loaded using File Open or the Decision Models Addin Loader.

The Calculation Settings Tables.

See FastExcel Calculation Settings for a detailed description of these options and how to set them

You can use the FastExcel Calculation Options button to change these calculation settings.

The Excel Calculation Settings Table

By default, Excel Calculation Settings apply to all currently open workbooks.

FastExcel Active Workbook mode allows you to control Calculation for the active workbook instead of all open workbooks.

Workbook Mode: All or Active Book.
The Excel default is to calculate all the open workbooks. With FastExcel you can restrict calculation to the active workbook only (and each workbook can have a different calculation mode, see Mixed Mode processing).

FastExcel Mixed Mode allows you to select sheets as MixMode sheets and control whether they will be calculated in Automatic, Manual or Sheet calculate.

Current Mode: Automatic, Manual or Semiautomatic.
This mode applies to all the open workbooks or just to the active book. The Excel default is to apply this mode to all the worksheets in a book. With FastExcel’s Mixed Mode you can control which worksheets are calculated in Automatic or Manual or Sheet Calculate mode.

Before Save:
If True Excel will recalculate before each save. Any worksheets that are NOT enabled for calculation will not be calculated.

Initial Mode: Controls how Excel sets the calculation mode when started.
First Workbook (Excel Default): Calculation mode is set from the first workbook opened.
Automatic: Calculation mode will be set to automatic.
Manual: Calculation mode will be set to Manual.
Semi-Automatic: Calculation mode will be set to Automatic except Tables.

Iteration: If TRUE Excel will attempt to resolve circular references by iteration.

Max Iters: the maximum number of iterations used to resolve circular references.

MaxChange: Iteration will stop when no cell changes by more than MaxChange

Multi-Threaded Calc: Calculation using multiple cores and threads

On: True/False/ #N/A Shows if Multi-Threaded Calculation (MTC) is on, off or not available

Mode: Automatic – Excel assigns a calculation thread to each available core. Manual – the user has assigned a specific number of threads.

Threads: The number of threads assigned to the calculation.

Force Full Calc: Shows if this workbook will use Excel’s smart recalc or always calculate every formula in the workbook at each calculation.

Full/Recalc:
Full: every formula in all open workbooks will be calculated at each calculation
Recalc: only changed formulas and formulas dependent on changed values/volatile cells will be recalculated

XL 64K Limit: in Excel versions prior to Excel 2007 Excel switched to force-full calculation when dependencies exceeded 64K. Colored orange if this limit has been reached

The Workbook Calculation Settings Table

These settings can be different for each open workbook

Mixed Mode allows you to choose when any MixMode sheets will be calculated.

Full: If True any MixMode worksheets will be recalculated at each full recalculation (Ctrl/Alt/F9).

Manual: If True any MixMode worksheets will be recalculated at each Manual calculation (F9).

Selected Sheets: If true then any MixMode sheets that are selected will be calculated when Sheet Calculate or Shift-F9 is pressed.

You can use Mixed Mode so that some worksheets always calculate and others calculate only when you want.

Restore After Open: If True then FastExcel will automatically reset the calculation mode after the workbook has been opened to the mode that was active when the workbook was saved, or in Active Workbook Mode to the mode stored in the workbook

MixMode on Open: If Excel is in Automatic mode then all the MixMode sheets in the workbook being opened will be recalculated. If Excel is in Manual mode any MixMode sheets will not be calculated when the workbook is opened unless this option is True.

Update Remote Refs: If TRUE automatically update any remote references (DDE Links to other programs) whenever Excel recalculates.

Precision as Displayed: If TRUE uses the displayed value of all cells rather than their real value as input to subsequent formulas.
Be careful because this also permanently changes the values of numeric constants.

1904 Date System: if True changes the starting date from which all dates are calculated from January 1 1900 to January 2 1904.

Save External Link Values: If TRUE Excel saves values for links to external workbooks.

Book Calc Engine: The version number of the calculation engine that last calculated the workbook (if not Excel 2000 or a later version then N/A). Colored orange if less than the Application calculation version