Formula Explorer Pro V5 Beta 1
Formula Explorer Pro V5 is the follow-on, updated version of Lambda Explorer and Formula Explorer.
Explore, Debug, Change, View Precedents and Dependents.
Drill Down forwards and backwards to Precedents and Dependents.
Includes Name Manager Pro to create and manage Named Lambdas.
Supports Formulas in 21 Languages
Supports all the new Excel Functions (PIVOTBY, TRIMRANGE, REGEX ...)
Click the purple components to expand a Named Lambda to its formula, or click the light green component to contract an expanded Named Lambda
Installing Formula Explorer V5
The downloaded file is a code-signed XLAM addin file.
Copy the XLAM file from your Downloads folder to a folder of your choice.
Unblock the XLAM file (right-click the file, choose the Properties Tab and Unblock).
Adding the XLAM to Excel
Use the Excel Addin Manager to install or uninstall Formula Explorer V5.
Or for single-session use just use Excel to open the XLAM file.
- Click the File Tab
- Select Options
- Click Addins
- Select Excel Addins in the dropdown
- Click Go
- Click Browse and locate the FormulaExplorer.xlam file
- Click OK
- Make sure that the Formula Explorer Addin is checked
- Click OK to return to Excel
When successfully installed in Excel you should see this Formula Explorer V5 Tab
If the Formula Explorer Tab is not visible make the Formula Explorer Folder a Trusted Location
- Click the File Tab
- Select Options
- Select Trust Center
- Click Trust Center Settings
- Select Trusted Locations
- Click Add New Location
- Browse to the Folder where you stored the Formula Explorer File
- Click OK to return to Excel
- Then close and restart Excel
|
