FastExcel Manager Pro Beta 3.0

FastExcel Manager Pro Beta 3.0 Build 383.794

Watch the Video Explorer 2 Overview

This build expires on the 30th of November 2018

Supports Mac Excel Version 16 and Windows Excel 2007 through Excel 2016 and all Windows Office 365 versions

Summary of changes in Explorer Pro 383 and 382

  • Changes for Excel Dynamic Arrays and Linked Data Types
  • Clean Workbook form persistence solved
  • Fix for Trial License Expiry message
  • Improved formatting for the Source/reference Box
  • Auto resizing of Explorer Pro for high resolution screens.
  • Fixes for % and Unary Minus operators with structured references.
  • Additional Settings
  • Smart Scroll improvements
  • Changes to handling of Modeless Userforms
  • Mac Excel timing resolution limited to 4 milliseconds
  • Updated documentation
  • Implementation of Licensing
  • Many bug fixes

Installing the Beta

Download the Beta zip file

The Zip file contains:
  • fxlMgrPro383.xlam
  • FastExcel Manager Pro.pdf
  • FastExcel Manager Pro Beta 3.0 Known Issues.docx
  • License_FXLMgrPro.txt
When you unzip the Beta the fxlMgrPro383.xlam file will probably have its blocked property set by Windows because its a downloaded file.
Before you can use the xlam file you will need to unblock it:
  • Unzip the downloaded Beta 3.0 file
  • Right-click on the xlam file
  • Select Properties
  • Click the Unblock button

Then Start Excel and install the Beta xlam using Excel's Addin Manager

Please report your bugs, suggestions and comments to Charles Williams

FastExcel Manager Pro: Workbook Management Tools

  • Formula Explorer Pro:
    Combines and extends Excel’s Evaluate Formula and Trace Precedents tools to give you improved ways of viewing, validating, debugging and editing Excel formulas:
    • Modeless and resizeable Form – select and modify cells whilst Explorer Pro is showing
    • Indented formula view and Expression Tree View show how the parts of your formula fit together, simplifies bracket forests
    • Drilldown from references to their formulas using Shift-click
    • Auto scroll to show selected cells
    • Show formulas and functions in English or local language.
    • Contract/expand the Treeview of sub-expressions and results
    • Forwards and Backwards debug using your arrow keys
    • Toggle between Expressions and Precedents view
    • Precedents view shows which precedents contain formulas
    • Precedents include INDIRECT, OFFSET, INDEX and their source cells
    • Click a reference or function to color and select its precedents both within and across worksheets.
    • Show the source cells that functions like VLOOKUP, SUMIFS, MAX etc are pulling from
    • Colors the selected result of IF, CHOOSE, IFS, SWITCH
    • See the results of individual criterias in SUMIFS, COUNTIFS etc
    • Show and filter the result values from ranges and array expressions.
    • Show filtered results from the arguments of functions like SUMPRODUCT
    • Handles Structured References, 3D references, Named Ranges, Dynamic Ranges, Intersect, Union, Complex References, Whole Column ranges, Used-Range intersection, Constant Arrays and more.
    • Use the Tooltips, Online help and PDF User guide for a fast understanding of Formula Explorer Pro
  • Calculation Manager:
    Addition calculation modes (Active Workbook Only etc.) and full control of Excel’s calculation process.
  • Name Manager Pro:
    Name Manager Pro greatly simplifies management and maintenance of Excel Defined Names.
  • Sheet Manager:
    Sheet Manager provides an easy way of managing a large number of sheets in a workbook.
  • Clean Workbook:
    Clean workbook gives you a comprehensive set of tools for eliminating wasted space and maintaining your workbooks.
  • Map Styles & Names:
    Produces where-used maps of Styles and Defined Names.
  • Memory Used:
    Shows used and available virtual memory for Excel.
  • Check Workbook:
    Produces a report showing workbook statistics and recommended areas for Clean Workbook.

Summary of changes in Explorer Pro 366

  • Fix for GoTo Hidden Sheets
  • Function syntax shown in Tooltips by default
  • Resizing of Origin/Destination box
  • Returns to Home Cell on close
  • Changing Settings refreshes the expression boxes

Summary of changes in Explorer Pro 364

  • Fix for spaces in column names in Tables
  • Fix for @ThisRow in Tables
  • Smart Scroll only active within the Excel Window
  • Smart Scroll Off by Default
  • Returns to Home Cell on close
  • Control-Home centres and resizes Explorer Pro
  • Fix for splitter bar hiding Vertical Scroll Bar
  • Settings form has button to Reshow Hints
  • Settings Form has button to Centre and Resize Explorer Pro
  • Fixes for Alt Arrow Keys expanding and contracting the Treeviews
  • Modeless Forms use Windows API

Summary of changes in Explorer Pro Beta 2.5

Significant performance improvements

Supports Formulas in 91 Languages

Alt-Enter to put the Indented formula back into the Home cell

Improved and simplified User Interface

  • Left-click to select: Shift-click to drill-down
  • Auto-Scroll a clicked item into view on the worksheet
  • Precedents view show which Precedents contain formulas
  • Command button Icons
  • Arrow keys:
    • Up Arrow/Down Arrow: move up or down an expression
    • Right Arrow/Left Arrow: Step forward and backward in Debug mode
  • More compact Explorer Pro userform
  • Hot-keys for resizing and moving Explorer Pro
    • Ctrl-End: Move bottom right
    • Ctrl-Shift-End: Move bottom left
    • Ctrl-Up Arrow: Increase Userform size
    • Ctrl-Down Arrow: Decrease Userform size
  • Settings to control Precedent coloring

Many bug fixes and limitations removed

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