← Back to listings

Rainbow Analyst

Published by The Model Answer

Excel VBA add-in from The Model Answer (founder Mike Shallcross; 64 Faringford Road, London E15 4DW, United Kingdom; support@themodelanswer.com; +44 (0)20 8519 4677) that audits, compares, and cleans Microsoft Excel workbooks from a Rainbow tab on Windows. Homepage title Rainbow Analyst | Rainbow Analyst spreadsheet audit software: Rainbow Analyst Spreadsheet Auditing Tool; FOUR Excel Auditing Tools in ONE Add-In; 30-Day No-Obligation Free Trial; Detect and fix hidden spreadsheet errors. Homepage: Rainbow Analyst (named for its unrivalled use of colour-coding) combines several areas of world-class spreadsheet auditing functionality: Excel spreadsheet audit and analysis tools with formula grouping and >50 analysis options; Spreadsheet comparison tools to track differences in cell formulas, macro code and other content; Unique spreadsheet clean-up tools which can even repair Excel's underlying XML files; An audit sampling tool with three different methods of sample selection and a sample size calculator. Key functions listed: Summary Report; Password Tool; Structure Map; Formula Scan map; Formula Scan report; Issue Tracker; Data Explorer; Cell Inspector; Risk Map; Quick Clean-Up; Deep Clean; Comparison Toolbox. About page title About Us | Rainbow Analyst: Mike set up The Model Answer in 2000 as a financial modelling consultancy. At the same time, he started developing Rainbow Analyst, initially just for his own use in analysing and auditing Excel spreadsheets. Its key feature (and the reason for the name Rainbow Analyst) was a unique colour-coding system that makes it very easy to spot problems and inconsistencies. Before starting The Model Answer, Mike spent 17 years working for KPMG; trained as a chartered accountant (ICAEW) and chartered tax adviser (IoT). Copyright © 2022 Mike Shallcross and The Model Answer. Download page title Download | Rainbow Analyst: This page has all you need to download and install the latest update of our Rainbow Analyst spreadsheet audit add-in: Version 26.02.2; Release date 28 February 2026. 30-Day Free Trial / Simple installation: If you're new to Rainbow Analyst, you'll need to start by installing a 30-day free trial. This is a fully functional version, and you can simply purchase a licence to continue using it beyond the end of the trial period. Click the button below, then double-click the downloaded RainbowPro.msi file to install Rainbow. Next time you start Excel, just click the Rainbow tab to access all of Rainbow's functions. Manual installation Step 1 downloads Rainbow Analyst Professional 26.0 RainbowPro.xlam (and older Rainbow250.xlam … Rainbow072.xlam as prior-version files, not separate catalog products). Step 2: If your computer runs Microsoft Windows 8 or later, your Excel add-ins folder should be This PC > Windows (C:) > Users > [User Name] > AppData > Roaming > Microsoft > AddIns; copy the Rainbow add-in file and delete older RainbowPro.xlam copies. Step 3: Activate the Rainbow add-in from within Excel — File tab (the Office Button in Excel 2007), Options, Add-Ins, Manage Excel Add-Ins, Go, check Rainbow Pro; You should now see the Rainbow tab on your Excel ribbon menu. Licensing: After you purchase a Rainbow Analyst licence from our online store, you'll receive an email (normally within one working day) setting out your licence key; To activate your new licence, go to the Rainbow tab in Excel and click under the User Guide icon, then About Rainbow, and enter the name, email address, and licence key. Rainbow licences are per user rather than per machine. So you can install your licence on more than one machine, provided that only you will use it. Your licence entitles you to one or two years of support (via email) and upgrades starting from the date of purchase. And all Rainbow licences include a perpetual licence, allowing you to continue to use the version of Rainbow that was current when you were last entitled to support and upgrades. However, if you upgrade to a more recent version, it will install itself as a 30-day free trial (with no licence). Online Store title Online Store | Rainbow Analyst: Purchase Your Rainbow Licence; Rainbow Analyst Pro basic licence + 1 year of updates £70.00; Rainbow Analyst Pro extended licence + 2 years of updates £90.00; Rainbow Analyst Pro corporate licence + 1 year of updates £700.00; update SKUs £25.00 / £45.00 / £150.00. Product page Rainbow Analyst Pro basic licence + 1 year of updates: A single licence for the latest version of Rainbow Pro, plus 1 year of support and updates; On receipt of your order, we will send you a licence key that will enable you to convert your free-trial copy of Rainbow Pro into a fully-licensed version; after this you will still be able to continue using the same version of Rainbow. Managed Deployment Guide (https://www.themodelanswer.com/downloads/Rainbow-Managed-Deployment-Guide.pdf HTTP 200 application/pdf 300518 bytes, Mike Shallcross, 5 December 2025): classic (VBA) add-in for Excel; download the Windows installer file (RainbowPro.msi); When the user next opens Excel they will see a message asking them to click OK to activate Rainbow Analyst. This will include Rainbow in Excel's list of active classic add-ins, and it will add a Rainbow tab to the Excel ribbon menu; alternatively copy RainbowPro.xlam to C:\Users\[username]\AppData\Roaming\Microsoft\AddIns and activate through File > Options > Add-ins; Rainbow versions from 12.4.0 (14 August 2021) onwards use a Windows (MSI) installer; 32-bit or 64-bit version of Microsoft 365 (Office) XLSTART paths C:\Program Files (x86)\Microsoft Office\Office16\XLSTART (32-bit) and C:\Program Files\Microsoft Office\root\Office16\XLSTART (64-bit). Rainbow Changelog (https://www.themodelanswer.com/downloads/Rainbow-Changelog.pdf HTTP 200 application/pdf 200426 bytes): Version 26.02.2 – 28 February 2026; Using Office RibbonX Editor … deleted customUI.xml (for Excel 2007), leaving the almost identical customUI14.xml (for Excel 2010+); At the start of all 81 modules, replaced “… add-in for Excel 2007+” with “… add-in for Excel 2010+”. Support page title Support | Rainbow Analyst: User Guide on the Rainbow tab in Excel, or download Rainbow Analyst Pro 26.0 https://www.themodelanswer.com/downloads/rainbow260guide.xlsx HTTP 200 application/vnd.openxmlformats-officedocument.spreadsheetml.sheet 92488 bytes; FAQs cover Excel File > Options > Trust Center add-in load, Microsoft Group Policy settings for Office 2016 or Excel 2016 (Block all unmanaged add-ins), and unblocking RainbowPro.xlam in File Explorer after a July 2016 Microsoft Office Security Update. Live installer https://www.themodelanswer.com/downloads/RainbowPro.msi redirects to https://www.themodelanswer.com/wp/downloads/RainbowPro.msi HTTP 200 application/x-msdownload content-length 3309568 (last-modified Sat, 28 Feb 2026). Live add-in https://www.themodelanswer.com/downloads/RainbowPro.xlam redirects to https://www.themodelanswer.com/wp/downloads/RainbowPro.xlam HTTP 200 application/vnd.ms-excel.addin.macroenabled.12 content-length 2583178. Password Tool screenshot https://www.themodelanswer.com/wp/wp-content/uploads/sld_password_tool.png HTTP 200 image/png 105630 bytes. Homepage comparison PDF https://www.themodelanswer.com/downloads/Comparing-OAK-Rainbow.pdf HTTP 200 application/pdf 267236 bytes compares Rainbow with Operis Analysis Kit — that PDF is vendor comparison material, not a second catalog product. This listing is Rainbow Analyst Professional for Excel — not older Rainbow 25/24/12.x downloads as separate catalog rows, not the corporate vs basic licence SKUs as their own products, and not Operis Analysis Kit (OAK) or Spreadsheet Detective as their own catalog rows.

Price: Paid

Platforms: Windows

Excel versions: 2010, 2013, 2016, 2019, 2021, 2024, 365

utilitiesproductivity

Get started

Get from Microsoft StoreVisit websiteRead documentationGet support

  • Ablebits Text Toolkit

    A practical text cleanup toolkit for Excel with quick helpers for cleaning, splitting, standardizing, and transforming cell content at scale.

  • Ablebits Ultimate Suite for Excel

    Windows Excel add-in from Office Data Apps sp. z o.o. (Ablebits.com) that adds 70+ tools on Ablebits Data and Ablebits Tools ribbon tabs for merging tables, comparing sheets, removing duplicates, cleaning text, managing workbooks, editing formulas, date and time calculations, unpivoting, and other Excel tasks. This is the desktop Ultimate Suite for Microsoft Excel — not Ablebits Text Toolkit on Microsoft Marketplace (WA200001792) and not Ablebits Google Sheets add-ons. Install the Windows setup: close Excel, unzip the package, run setup.exe (Business edition installs to AppData\Local for the current user without admin rights; Personal edition requires admin rights), then start Excel and look for Ablebits Data and Ablebits Tools tabs. Download a free 14-day trial with no card or email required from ablebits.com/excel-suite. Windows only: Excel included in Microsoft 365 and Excel 2024, 2021, 2019, and 2016 (32- and 64-bit). Windows 10 and Windows 11 (x86; Copilot+ ARM; Parallels on Mac). Not Office Insider, not Windows Insider, and not Office from the Microsoft Store. Pricing (ablebits.com/excel-suite and ablebits.com/purchase): one-time license with no recurring fees; Personal $49 (single user, up to 2 computers); Business $99 (single user, up to 5 computers, GPO/SCCM); Business 5 seats $399; 2 years of free upgrades; 30-day money-back guarantee; volume discounts 5–15%; 50% charity discount. Publisher: Office Data Apps sp. z o.o., ul. Brukowa 3, 05-092 Łomianki, Poland. Support: support@ablebits.com / +1 201 351 3731.

  • ASAP Utilities

    Windows Excel add-in with 300+ practical tools for cleaning messy data, bulk sheet operations, and everyday tasks Excel cannot do on its own. Runs locally; Professional is a one-time license with a 90-day trial.

  • FastExcel V4

    Desktop Excel add-in family from Decision Models Ltd (Charles Williams, Leamington Spa, UK; company number 3190392) for finding calculation bottlenecks, maintaining workbooks, and speeding up Excel formulas. This is FastExcel Version 4 — not the unsupported FastExcel V3 product. The Windows family is three products: Profiler (drill-down wizard to the slowest formulas and sheets, workbook/formula/worksheet profiling, worksheet cross-references, VBA profiler, calculation timing); Manager Pro (Workbook Cleaner, Formula Explorer, Name Manager Pro, Sheet Manager, Check Workbook, where-used maps); and SpeedTools (100 superfast multi-threaded worksheet functions including 50 Dynamic Array functions, faster lookups and list comparisons, extra calculation modes). A freely distributable SpeedTools Run-Time ships those functions to user PCs. Manager Pro V4 is also available for Mac Excel 365. Install (Windows): download the digitally signed Automatic Installer (administrative privileges; Unblock the file after download) or the Manual installer (no admin; load .xlam files via Excel Add-in Manager and add the FastExcelV4 folder as a Trusted Location). Default automatic install is Program Files (x86)\FastExcel V4; FastExcel V4 ribbon tabs appear after Excel starts. Add-in files include FxlV4Profiler.xlam, FxlMgrPro.xlam, and FxlV4SpeedTools.xlam plus 32/64-bit XLLs. Mac: copy fxlMgrProMac.xlam and load via Tools→Excel Add-ins. Windows: 32- or 64-bit Excel 2010, 2013, 2016, 2019, 2021, or Office 365 Excel; Windows 7, 8, 10, or 11; .NET 4 or later. Mac: Office 365 Excel. Not Excel Online. Request a 15-day FastExcel V4 Bundle trial (trial restricts profiling to a single worksheet); convert anytime with a purchased activation code. A single product license activates on 2 systems. Pricing (FastSpring merchant of record, excluding VAT): FastExcel V4 Windows Bundle $219; Profiler $109; Manager Pro for Windows $79; SpeedTools $69; SpeedTools Run-Time $59; Manager Pro for Mac Office 365 $79. The Windows bundle saves $38 versus buying the individual Windows products. Volume example: 30 SpeedTools V4 licenses $31/unit ($930). 30% upgrade discount for existing FastExcel V3 customers. Support: FastExcel V4 Google Group and Charles@DecisionModels.com. Publisher: Decision Models Ltd, 17 Binswood Avenue, Leamington Spa, Warwickshire CV32 5SE, UK. Telephone (44)-1926-334289.

  • Formula Audit XL

    Microsoft Excel Office.js task-pane add-in from Scalarly Srl (marketplace title Formula Audit XL, AppSource WA200012399, publisher Scalarly / PN200007631, builtFor Microsoft 365, AppVersion 1.0.0.0) that installs from the Microsoft Marketplace Excel add-in store and opens a Formula Audit tab / Home-tab Audit model command so you can run Model Check, precedent and dependent trees, cell mapping and formula-pattern checks on the open workbook. Marketplace title Formula Audit XL | Microsoft Marketplace (https://marketplace.microsoft.com/en-us/product/office/WA200012399 HTTP 200): Formula Audit XL by Scalarly; Get it now (CTA_Get). Marketplace JSON (https://marketplace.microsoft.com/view/app/WA200012399?country=US HTTP 200): appActionType FREE; hasPrices false; additionalPurchasesRequired true; WorksWith Excel_2016, Excel_2016_Mac, Excel_2019, Excel_2019_Mac, Excel_Online, Mac_Excel, Win32_Excel, Excel_M365_Mac, Excel_M365_Win; ReleaseDate 2026-10-03; AppVersion 1.0.0.0; SupportLink https://formulaudit.com/contact; PrivacyPolicyUrl https://formulaudit.com/privacy; determinedStorefronts Appsource; linkedAddIns empty; short description Find the broken formulas in any Excel model before someone else does. Marketplace description: Formula Audit XL audits the spreadsheets your decisions rest on; it runs as a task pane in Excel on Windows, on Mac and on the web; Model Check sweeps circular references, broken and unused names, external links, inconsistent formulas, and hardcoded numbers; each finding is ranked by severity and Go selects that cell; the Sheets tab shows formula and issue counts per sheet; the Trace tab lists precedents and dependents of the selected cell; workbooks never leave the device (Excel JavaScript API, analysis inside the pane); free 7-day trial with every feature unlocked, no sign-up / email / credit card; after the trial buy a licence on formulaudit.com. Vendor product title Formula Audit XL: audit any Excel model (https://formulaudit.com/ HTTP 200): Excel formula auditing add-in from Scalarly Srl (Via Borghetto 3, 20122 Milan, Italy; P.IVA IT08592260965). Vendor task-pane install docs title Install Formula Audit XL in Excel on the web, Windows or Mac (https://formulaudit.com/docs/excel-web-addin/ HTTP 200): Microsoft AppSource listing WA200012399; in Excel open a workbook, Home tab -> Add-ins, search Formula Audit XL, Add; then open the Formula Audit tab (version 1.0 listing: Audit model on the Home tab); task pane edition runs on Excel on the web, Excel for Windows 2016 or later, and Excel for Mac with no installer; Formula Audit tab and shortcuts need Microsoft 365, Excel 2021 or later, or Excel on the web; Excel 2016 and 2019 get the task pane without the tab and the shortcuts; optional sideload via https://formulaudit.com/addin/manifest.xml or Microsoft 365 Centralized Deployment. Catalog platforms follow that task-pane matrix. Vendor pricing title Formula Audit XL Pricing: Free trial, Yearly & Lifetime (https://formulaudit.com/pricing/ HTTP 200): Free trial $0 for 7 days; Yearly $3/mo billed yearly ($36 once a year); Lifetime $129 one-time (30-day money-back); after 7 days the add-in locks until a licence is purchased; one key, both editions (task pane and Windows installer) with a single-seat key active on one of them at a time. Vendor support title Contact Formula Audit XL (https://formulaudit.com/contact/ HTTP 200). Vendor privacy title Privacy policy: Formula Audit XL (https://formulaudit.com/privacy/ HTTP 200): last updated 1 May 2026; Scalarly Srl; task pane processes workbooks locally through the Excel JavaScript API; licence check sends key, add-in version, and a one-way device identifier. Marketplace Get it now is free to install; paid use is Yearly $36/year or Lifetime $129 after the 7-day trial. This listing is the Excel Office.js task-pane add-in Formula Audit XL WA200012399 — not the separate Windows .xlam installer as a standalone catalog row, the free in-browser circular-reference / link / hardcode finder web tools, sideload / Centralized Deployment as standalone products, or other formula-audit add-ins.

  • Kutools for Excel

    Comprehensive workbook utility add-in with hundreds of productivity shortcuts for formatting, workbook operations, and batch data cleanup.