Find Excel spreadsheet errors with Rainbow Analyst spreadsheet audit software

Save time and costs on Excel spreadsheet audit, review and comparison

Rainbow Pro tab


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”.

Rainbow comes in two versions, Rainbow Analyst Professional (Rainbow Pro) and Rainbow Analyst Personal. As you can see from the composite screenshot above, the latest version of Rainbow Pro offers you a choice of two different menus (Standard and Advanced), giving you access to a wide range of Excel spreadsheet audit and analysis tools to help you find even the most well-hidden spreadsheet errors. Click the buttons below to check out either version of Rainbow for free:

Download Rainbow Analyst Professional 8.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).

After downloading, 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.

Spreadsheet error chart

Try the Rainbow test!

Many research studies (both academic and commercial) have shown that all spreadsheets contain errors. The screenshot above right shows how Rainbow Analyst Pro highlights some potential errors, and the fact is that without Excel audit software such as Rainbow Analyst, many spreadsheet errors are likely to go undetected. If you’re not convinced, you can try the Rainbow test for yourself:

It took Rainbow Pro just 4 seconds to highlight this spreadsheet, and we’re willing to bet that it saved you a lot more time than that in finding the error (which you can see very clearly in this unedited screenshot). And this was just a trivial error (that didn’t actually affect the calculated value) in a small spreadsheet; imagine the difference that Rainbow Pro could make with a large spreadsheet where the results actually matter. With prices starting from just £29 for commercial use, can you afford not to have Rainbow Pro on your Excel menu?

Why choose Rainbow?

The slides on the right (which are based on Rainbow Pro version 8.1) illustrate some of Rainbow Pro’s key features; just click on any slide to see more information about the relevant feature.

Of course there are competitor products that have a few features that Rainbow doesn’t have, and Rainbow has some features (such as the Logic Map and the Data Explorer) that our competitors lack. But we think that Rainbow stands out from the crowd for its exceptional usability and user interface. To find out for yourself, just click the button above to download your free trial copy, or go to our Products page to buy a copy for yourself.

And if you’re using Excel 2013 or Office 365 with the free Spreadsheet Inquire add-in, you should probably read this independent report which explains why the Inquire add-in is no substitute for a tool like Rainbow Pro. You’ll see from pp.4-5 of the report that because of the way it looks at formulas, Spreadsheet Inquire wouldn’t even help you find the error in our “Rainbow test” above.

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

10% discount as Rainbow goes to Delft

10% discount as Rainbow goes to Delft

We’ve been a member of the European Spreadsheet Risks Interest Group (EuSpRIG) for some years, and on 3rd July we’ll be attending the 2014 Annual Conference, where we’ll be giving a brief demonstration of Rainbow Pro in use. So if you’re interested or you’re in the area, please do register and come along for the…Continue Reading

Rainbow Pro 8.1 easier for new users

Rainbow Pro 8.1 easier for new users

We’re very proud of Rainbow Pro’s rich set of analysis functions, but a few users have told us they have found it difficult to know which functions to use, and they would like something simpler. So we’ve responded to this by releasing Rainbow Pro version 8.1, which has a dual-menu system, as you can see…Continue Reading

Do it with fewer clicks in Rainbow Pro 8.0

Do it with fewer clicks in Rainbow Pro 8.0

We’re always looking for ways to make Rainbow easier and quicker to use, and the latest release of Rainbow Pro 8.0 helps you get where you’re going with considerably fewer mouse clicks. Even the Rainbow installer (the RainbowPro.exe file that you download) now makes things much easier; it not only copies the Rainbow add-in file…Continue Reading

Back to topAdministration