CalcoraSuite questions, answered on one page

CalcoraSuite questions from every page on this site are collected here and linked to where each is answered: 40 in total, covering the product, the comparisons, the how-to guides and the glossary.

About the product

Does CalcoraSuite change my workbook?
The audit and the formula explorer read the workbook. Nothing is written back to a file unless you export a findings list, and an export is a separate step you start.
Which Office applications are supported?
Windows desktop Excel is the first target, because that is where the models are. PowerPoint and Word follow, and the web versions of Office are not supported.
Does the AI assistant send my model anywhere?
No. The assistant is off by default and runs against a model on your own machine. A remote endpoint is used only if you switch one on yourself, knowing where it points.
Can I use it on a confidential model?
That is what the design is for: the add-ins run inside Office on your machine, and the default assistant endpoint is local. The security page sets out what leaves your computer, which is nothing by default.

Comparisons

How does CalcoraSuite compare with Arixcel?
CalcoraSuite vs Arixcel comes down to scope. Arixcel's own pages describe a formula explorer, spreadsheet comparison with alignment, formula mapping and multi-cell tracing in Excel; CalcoraSuite adds PowerPoint and Word review, a local AI assistant and an audit that cites the cell behind each finding.
How does CalcoraSuite compare with Copilot in Excel?
CalcoraSuite vs Copilot in Excel is a comparison of two jobs. Microsoft describes Copilot as a chat assistant inside Excel that suggests formulas, analyses data and builds charts; CalcoraSuite checks whether a finished model is internally consistent, on your own machine.
How does CalcoraSuite compare with Macabacus?
CalcoraSuite vs Macabacus sets a plan against a shipped suite. Macabacus's own pages describe deck checking, shared libraries, tombstones and a large shortcut set; CalcoraSuite is narrower, aimed at finding formula faults and keeping the review on your machine, and it is not released yet.
How does CalcoraSuite compare with UpSlide?
CalcoraSuite vs UpSlide comes down to the job. UpSlide's own pages describe document production across PowerPoint, Word, Excel, Outlook and Power BI, with templates, tombstone libraries and track changes; CalcoraSuite stays with review work in Excel, PowerPoint and Word, and does not attempt document production.

How-to questions

How to audit a financial model in Excel?
To audit a financial model in Excel, use the Inquire tab: Workbook Analysis reports formulas, cells, ranges and warnings for the whole workbook. Then check hardcoded constants with Go To Special and trace the key totals with Trace Precedents. The findings still need a reviewer's judgement.
How to compare two Excel workbooks?
To compare two Excel workbooks, open both, then use the Inquire tab and choose Compare Files. Spreadsheet Compare shows the differences cell by cell, colour-coded by kind, and can export the result. Microsoft documents it for Excel for Windows in Microsoft 365 Apps for enterprise plans.
How to find hardcoded numbers in Excel?
To find hardcoded numbers in Excel, press Ctrl+G, choose Special, then select Constants and clear the text and logical options so only numbers are selected. Excel highlights every typed number in the range, which is where a review usually starts.
How to link an Excel chart to PowerPoint?
To link an Excel chart to PowerPoint, copy the chart in Excel, paste it on the slide with Ctrl+V, then open Paste Options and choose Keep Source Formatting and Link Data. The chart stays tied to the workbook and updates when the source data changes.
How to link Excel to Word?
To link Excel to Word, copy the range in Excel, paste it into Word with Ctrl+V, then open Paste Options and choose Link and Keep Source Formatting. The table stays tied to the worksheet and updates when the source data changes.
How to trace dependents in Excel?
To trace dependents in Excel, select the cell and use Formulas, then Formula Auditing and Trace Dependents. Arrows point from your cell to every formula that reads it. Click again to go further. Excel beeps when every level is traced, or when the cell cannot be traced at all.
How to trace precedents across sheets in Excel?
To trace precedents across sheets, select the formula cell, open Formulas, then Formula Auditing and click Trace Precedents. Arrows appear for references on the same sheet. For a reference on another sheet, double-click the black arrow to open the Go To dialog, then pick the reference.

Definitions

What is a #ref! error?
A #REF! error appears when a formula refers to a cell or range that has been deleted or moved, so the reference itself can no longer be resolved.
What is a array formula?
An array formula is a formula that returns one or many results from a range, calculated as a set rather than by copying the formula down each row.
What is a audit trail?
An audit trail is a record of changes made to a file, and in a spreadsheet it is what lets a reviewer tell a deliberate edit from an accident.
What is a calculation chain?
The calculation chain is Excel's record of which cells depend on which, used to decide what to recalculate and in what order when something changes.
What is a circular reference?
A circular reference occurs when a formula refers back to its own cell, directly or through a chain, so the calculation cannot resolve without either an iteration setting or a fixed input.
What is a dead cell?
A dead cell is a formula whose result is never used by another cell, a chart or an output, so it can be wrong without anyone noticing.
What is a dependent cell?
A dependent cell contains a formula that refers to another cell, so a list of dependents answers the question of what breaks if that cell changes.
What is a dynamic array?
A dynamic array is a formula whose results spill into as many cells as it needs, so one formula replaces a column of copied formulas.
What is a external link?
An external link is a reference from one workbook to a cell or a name in another file, so the value depends on a file the reader may not have.
What is a formula auditing?
Formula auditing is the set of Excel commands that display relationships between cells, evaluate a formula step by step and locate errors, all grouped on the Formulas tab.
What is a hard-coded value?
A hardcode is a number typed directly into a formula or a calculation cell instead of being referenced from an input, which breaks the trail from a result back to its assumption.
What is a implicit intersection?
Implicit intersection is the rule that lets a formula written for a single cell quietly pick one value from a range instead of returning an error.
What is a input cell?
An input cell is a cell that holds an assumption a person is meant to change, which is why a typed number there is correct and the same number in a calculation block is not.
What is a model risk?
Model risk is the possibility that a decision based on a model turns out wrong because the model itself was built incorrectly, misused or fed bad inputs.
What is a named range?
A named range is a name that stands in for a cell, a block or a formula, so a reader sees a word where the reference would otherwise be.
What is a precedent cell?
A precedent cell is a cell that a formula in another cell refers to, so following precedents is how a reviewer walks a total back to the numbers it depends on.
What is a r1c1 notation?
R1C1 notation writes a reference as a row and column count relative to the current cell, so R1C1 notation describes the shape of a copied formula rather than a fixed address.
What is a sensitivity table?
A sensitivity table recalculates a model's output across a grid of input values, so one cell holds the result for every combination in the grid.
What is a spill range?
A spill range is the block of cells that a single dynamic array formula fills with its results, and it is the range Excel reserves so the output has somewhere to land.
What is a structured reference?
A structured reference names a table and a column instead of a range, so the reference grows and shrinks with the table rather than staying fixed.
What is a three-statement model?
A three-statement model is a financial model where the income statement, the balance sheet and the cash flow statement are built from the same drivers and tie together.
What is a tracer arrow?
A tracer arrow is the line drawn by Trace Precedents or Trace Dependents to show the relationship between a formula and the cells it reads or feeds.
What is a version drift?
Version drift is the divergence between two copies of a workbook that were once the same, usually because one copy kept changing while the other stayed in circulation.
What is a volatile function?
A volatile function is one Excel recalculates whenever anything in the workbook changes, because Excel cannot tell whether its inputs have changed.
What is a workbook link?
A workbook link is a stored reference from one Excel file to a cell or name in another, and it depends on the other file staying where it was when the link was created.

Not answered here?

Ask by email; questions that keep coming up get added to this page and to the page they belong on.