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.

For a 4-minute introduction to spreadsheet auditing with Rainbow Pro, using a real-life financial model, click the video link on the right or watch on YouTube. And then click the Download button below to install your 30-day free trial copy of Rainbow Pro and check it out for yourself!

Spreadsheet Auditing in 3 Steps

Download Rainbow Analyst Professional 10.0, our flagship product for Excel versions from 2007 to 2016.

(Note: Because Rainbow Analyst is not a commonly-used application, Windows SmartScreen may report the download file as an “unrecognised application” and stop it running. If this happens, just click “More info” in the SmartScreen message, then click the “Run anyway” button.)

Reviewing and auditing
With the issue-flagging and collaborative messaging features introduced in Rainbow Pro 9.2, systematic Excel spreadsheet audit and review can now be as easy as 1-2-3, using the first 3 functions on Rainbow's Standard menu (shown above): Run 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 [more]
Comparing differences
One of our customers told us Rainbow was worth buying for its comparison function alone, and another customer found an unexpected use for it in resolving version conflicts. Rainbow's Comparison Toolbox function provides you with a whole toolbox of different options, allowing you to compare different workbooks, worksheets or ranges. And at the same time Rainbow lets you choose whether you want [more]
Cleaning up errors
Have you come across that annoying "Too many different cell formats" error message? This often occurs as a result of copying or importing worksheets from one workbook into another, as described in our earlier news item, and it can be very difficult to eliminate manually. Fortunately, as you can see from the composite screenshot above, Rainbow Pro comes with a function called Clean Up For [more]
Checking data flows
With Excel increasingly used for Business Information (BI) projects, it's essential to keep track of the sources of data in your spreadsheet. Unlike most other spreadsheet utilities, Rainbow gives you a number of tools to help with this, and the most important of these is probably the Data Explorer, which gives you a pair of linked reports showing: All the pivot tables, query tables and [more]
Rainbow 10.0 adds perpetual licence
For Rainbow 10, we've responded to requests from a number of users for Rainbow to include a perpetua [more]
Rainbow 9.3 for Excel 2016
Microsoft have always said that VBA (the language in which Rainbow is written) will be supported for [more]
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 [more]
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 u [more]
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-rele [more]
Stop “Too many different cell formats” errors
Have you encountered a "Too many different cell formats" error message? This often occurs as a resul [more]
Back to topAdministration