Find Excel spreadsheet errors fast with Rainbow Analyst spreadsheet audit tools

Rainbow Analyst is a spreadsheet auditing and visualisation add-in for Microsoft Excel™ that has been ranked #1 in an independent study at the University of Stuttgart and is in regular use by one of the UK’s largest accounting firms.

It can pay for its cost within weeks, as a recent customer told us: “Rainbow Pro has paid for itself already when it was able to remove 150,000 named ranges (most of them nonsensical) from a very large file that ran out of resources using conventional means”.

Spreadsheet Auditing in 3 Steps

For a 4-minute introduction to spreadsheet auditing with Rainbow Pro, press F11 (in most browsers) to switch to full-screen, then click the video link above, and then you can just click the screen to start or pause. You can also view the video on the YouTube website, and you can download the example financial model that we used for this demo and follow the steps for yourself with a free trial copy of Rainbow Pro.

Download Rainbow Analyst Professional 9.2, our flagship product for Excel 2007 onwards.

Click the button above to get your 30-day free trial of Rainbow Analyst Professional (Rainbow Pro); simply double-click the downloaded file and follow the instructions to install Rainbow for your copy of Excel. And if you’ve any questions, just visit our Installation page or send us an email.

Excel spreadsheet audit or review – as easy as 1-2-3

Rainbow Pro tab


With the new issue-flagging and collaborative messaging features in Rainbow Pro 9.2, systematic spreadsheet auditing can now be as easy as 1-2-3:

Step 1Run the Summary Report function to get a high-level overview of the spreadsheet. Decide what action is required to address any problems highlighted on the report, particularly any red highlights.


Step 2Run the Formula Scan function, with formula checking and issue flagging turned on. Visually inspect the resulting colour map of formula groups, and investigate any obvious inconsistencies or isolated formulas.


Step 3Use the Issue Tracker (F10) to work systematically through issues that Rainbow has identified and flagged, and record the results. And use the Cell Inspector (ALT+F10) to check the logic of any suspicious formulas.


Save time and costs in auditing or comparing Excel spreadsheets

Rainbow Pro tab


And if you’re less interested in spreadsheet auditing than in tracking changes between spreadsheet versions, then Rainbow’s Comparison Toolbox may be the solution for you. As one customer told us, “I tried it out on 2 large files and I have bought it for the comparisons alone!”

As you can see from the screenshots further up the page and above, Rainbow Pro offers you two different ribbon menus (Standard and Advanced), and there is also a Personal version of Rainbow Analyst which still offers many of Rainbow’s core functions. Click the buttons below to check out either version of Rainbow:

Download Rainbow Analyst Professional 9.2, our flagship product for Excel 2007 onwards (30-day free trial).

Download Rainbow Analyst Personal 5, an older version of Rainbow for Excel 2000 onwards (completely free).

And if you think that you don’t need a tool like Rainbow Analyst because you can find the errors in your spreadsheets by manual inspection, then try the “Rainbow test” on our Why Rainbow page.

Save 20% and get answers faster

Save 20% and get answers faster

As it’s still the holiday season, we’re offering 20% off Finance and Business licences for the latest version (9.2.4) of Rainbow Pro until September 12th! And for this you get our fastest ever implementation of the Summary Report; particularly if your spreadsheet is data-heavy, the Summary Report will now zip through in a fraction of… Continue Reading

Rainbow 9.2 saves time for your team

Rainbow 9.2 saves time for your team

With Rainbow 9.2 we’ve built on the behind-the-scenes changes in version 9.0 to deliver significant new front-end capabilities: We’ve integrated Rainbow’s in-depth testing capabilities (in Risk Map and Logic Analysis) into the Formula Scan function (renamed from Formula Groups). Formula Scan can now perform a battery of tests on each formula as it scans, and… Continue Reading

Sniff out spreadsheet “smells” with new Rainbow 9.0

Sniff out spreadsheet “smells” with new Rainbow 9.0

Today we’re proud to release version 9.0 of Rainbow Pro, representing perhaps the most significant upgrade for several years. The most obvious change is that the Rainbow tab on the Excel ribbon menu has a new set of icons in the “flat” style used by current versions of Microsoft Excel and Windows. But beneath the… Continue Reading

New Rainbow Pro 8.2 more intuitive than ever

New Rainbow Pro 8.2 more intuitive than ever

We’re always looking for ways to make Rainbow Pro easier to understand and use, and in the just-released version 8.2 we’ve built on our “interactive reports” technology to deliver a whole new level of product integration. You can see this very clearly in the Summary Report screenshot above, showing the 20 interactive buttons (in column… Continue Reading

Stop “Too many different cell formats” errors

Stop “Too many different cell formats” errors

Have you encountered a “Too many different cell formats” error message? This often occurs as a result of copying or importing worksheets from one workbook into another, because by default Excel also imports all the custom styles (cell formats) from the source workbook. Generally there are about 50 basic styles, but when worksheets have been… Continue Reading

Back to topAdministration