ExceLab Add-in Frequently Asked Questions

Can I install ExceLab on my MacBook?

Absolutely. Install directly from Microsoft AppSource. Open Excel. From the Insert Tab on the Ribbon click on Get Add-ins. To find ExceLab 365 in the Microsoft AppSource search for calculus, then click Add to enable the add-in.

I have a non-English Windows OS. Can I install ExceLab?

Absolutely. Excelab Add-in can be installed on any localized Windows version. However, you will continue to receive solver notification messages in the English language.

What is the difference between ExceLab 7.0 and ExceLab 365? Which one should I use?

If you are using an Apple Mac, you can only install ExceLab 365.

If you are using a Windows PC, you can install ExceLab 7.0 (or ExceLab 365 if you have Office 365 subscription).

Main differences between ExceLab 7.0 with and ExceLab 365

  • Calculation Engine

    ExceLab 7.0 calculation engine runs locally on your computer. ExceLab 365 calculation engine runs in the cloud

  • Performance

    ExceLab 7.0 is significantly faster without any internet-induced latency or downtime. It is recommended for large and intensive computations.

  • Array Formulas

    ExceLab 365 supports a spill feature which allows you to evaluate an array formula solver like a simple formula by pressing ENTER and the formula will expand (spill) into neighboring cells with results. In ExceLab 7.0, array formulas must be evaluated in an allocated range of the spreadsheet with CTRL+SHIFT+ENTER. (See array formula.)

I am getting a #VALUE! error when I evaluate a solver formula.

There are many reasons why you might get a #VALUE! error.

  • If you are running ExceLab 7.0, by default, the solvers will report any error as a text result in your cell. If you get a #VALUE! error, then most likely Excel has a problem with your formula which is preventing it from executing the solver. In ExceLab 7.0, you can change how solvers report errors (see error reporting).

  • If you are running ExceLab 365, there will be an error message associated with #VALUE! error. To get at the error message, click on a cell with the #VALUE! error, then point at the error symbol to read the actual error message. For example, the error message below indicates that argument 2 is incorrect. The integration function, QUADF, expect the integration variable in parameter number 2 (e.g., X1) but we are passing the number 1 instead.

    Sometimes, Excel might return the following message with a #VALUE! error:

    This error is returned by Excel and not the solvers. It indicates that Excel is having a problem with the formula and could not execute the solver. If we inspect the formula, we notice that it is missing parameter number 4 which is required. If you get this error, inspect your formula to make sure you are passing all required parameters for a solver with proper types.

Question or Comment? Email us:
support @ excel-works.com

ExceLab: Transforming Excel into a Calculus Power House

ExceLab functions and methods are protected by USA Patents 10628634, 10114812, 9892108 and 9286286.

© 2015-2024, ExcelWorks LLC
Boston, USA