Troubleshooting
Last updated 10 November 2026
Error messages during installation, and the Repair Tool, are on Troubleshooting errors. Problems with Position Mapper and Confirmation Mapper are in their own guides: Position Mapper and Confirmation Mapper.
| What you see | What to do |
|---|---|
| There is no GIAnalyzer tab in Excel | Excel may have turned GIAnalyzer off. Turn it back on as in If the GIAnalyzer tab doesn't appear. If that doesn't help, run the Repair Tool. |
Every GIAnalyzer function shows #NAME? | The functions didn't load when Excel started. Restart Excel. If they still show #NAME?, run the Repair Tool: see If GIAnalyzer doesn't load. |
One function shows #NAME? | Excel doesn't recognise the name. Check it for typing errors, or find the function in the function reference. |
A function shows #NULL! or 0 | Your licence doesn't include the function's module, or has expired. The Other and Value at Risk functions need a Full licence. Open Licensing to check. In the Function Arguments window, #NULL! is expected: see Insert a function from the ribbon. |
| The Licensing window opens when I click a menu item | That module isn't in your licence, or the licence has expired. See Modules. |
| Calculate Selection, Calculate Function and Saving Options are greyed out | Excel is in automatic calculation mode. The tools work in manual mode: Formulas > Calculation Options > Manual. See Calculation tools. |
| Calculate Function says the sheet doesn't have the function | No cell's formula begins with that function, or the name is mistyped. A function inside a longer formula, such as =2*GIA_…(…), isn't counted. |
| An example workbook opens read-only | That is by design, so the original stays unchanged. Use File > Save As to save your own copy. |
| A workbook shows a security warning | Workbooks that end in .xlsm contain macros, for example for the cash-flow table buttons. Click Enable Content. |
| The Updates group is missing | It appears a few seconds after Excel starts, and only for the online version. The offline version is updated by hand: see Updating GIAnalyzer. |
| Map and Load Positions or Map and Load Confirmations is greyed out | Your licence doesn't include that mapper. The mappers are licensed separately: a Full licence doesn't include them. |
Contacting us
Click Contact us on the GIAnalyzer tab. It opens an email to info@gammaimpact.co.il that already holds your Windows, Excel and .NET versions; please leave them in. Tell us what you did, what you expected and what you saw, and attach a screenshot of the message if there is one.