Excel Lab
  • Excel Lab
  • Release Notes
  • Getting Started
    • Installing Excel Lab
      • Step 1: Download Files
      • Step 2: Register Libraries
      • Step 3: Activate Add-in
      • Step 4: Verify Installation
  • Functions
    • General
      • ISMATRIXPSD
      • MATRIX
      • XLABHELP
      • XLABINFO
      • XLABLICENSE
      • RESETPASSWORD
    • Return Models
      • CAPM
      • DESMOOTHRETURNS
      • IMPLIEDRETURNS
      • MLERETURNS
    • Risk Models
      • ANNUALIZERISK
      • EWMA
      • HISTORICALRISK
      • MLERISK
      • PORTFOLIORISK
      • TURBULENTRISK
      • QUIETRISK
    • Optimization
      • MVO
      • MTO
      • MVT
      • MVFRONTIER
      • MTFRONTIER
      • ISORETURN
    • Simulation
      • MCNORM
      • BOOTSTRAP
    • Exposure to Loss
      • LOSSPR
      • OMEGARATIO
      • SORTINORATIO
      • TAILRATIO
      • VALUEATRISK
      • MAXDD
    • Regression Analysis
      • FACTORANALYSIS
      • PSR
    • Scenario Analysis
      • MAHALANOBIS
      • SCENARIOPR
      • IMPLIEDSCENARIO
  • Frequently Asked Questions
    • Common Issues
    • FAQ
  • Further Reading
  • Windham's Research Insights
  • Watch Our Educational Videos
Powered by GitBook
On this page
  • Description
  • Syntax
  • Input(s)
  • Output(s)
  • Example
  1. Functions
  2. General

XLABLICENSE

Invoke authentication with licensing servers to enable or re-enable your use of Excel Lab.

PreviousXLABINFONextRESETPASSWORD

Last updated 1 year ago

Description

Excel Lab authenticates with Windham's licensing server for convenience and security. If you encounter issues with re-authentication, you will be able to manually invoke authentication my following the syntax as documented below in Excel's formula bar.

You can invoke Excel Lab's license authentication process anywhere in a workbook. You can even do this in a new blank workbook.

You do not need to save the workbook once authentication is successful.

Syntax

The following describes the function signature for use in Microsoft Excel's formula bar.

=XLABLICENSE()

Input(s)

Follow the on-screen dialog prompt to enter your username and password.

Argument
Description

Username

Your e-mail address registered with Windham Labs.

Password

Your password, or unlock key code for offline use. The offline unlock key code is only available for yearly billing plans.

Output(s)

Message
Description

Valid

Credentials (username / password) and account successfully authenticated. Enjoy ExcelLab!

Invalid Credentials

Invalid username and/or password. Check for typos, try again.

Inactive

Your account is no longer active.

Invalid Permissions

Your account is not permissioned for the product / feature.

Expired

Your account has expired.

Invalid Host

Unauthorized device. Each Excel Lab license is locked to a device.

Missing Credentials

No input for either username or password. Please try again.

Example

To manually authenticated

  1. Open any workbook, or create a new (temporary) workbook.

  2. In any cell, type =XLABLICENSE() in the formula bar.

  3. Follow the instructions as described in the Syntax section above.

When successful, Excel Lab will store your license information within user-specific system files. You do not need to save the temporary workbook.

A workbook using Excel Lab requiring re-authentication
Invoke licensing via the Formula Bar