Latest Updates
News Archive
Here you’ll find details of each major update to our Rainbow Analyst spreadsheet audit Excel add-in. And to keep in touch, you can also follow our Facebook page.
Deep Structure report and installation clean-up
In our last post we introduced the new Deep Structure function in Rainbow, which you’ll find on the menu under Summary Report. This lets you see at a glance which are the largest worksheets (tabs) in your workbook, and what sort of content each worksheet holds. And…
Rainbow 26.02 reveals what’s buried in your workbook
Did you know that there’s a completely different way of looking at an Excel spreadsheet? And that it can show you information that you didn’t know was there, helping you avoid disastrous errors like the leak of data about Afghan personnel in 2022 that was…
See a logic map of your whole workbook with Rainbow 25.01
There’s been a Logic Map function in Rainbow for some time, showing you very useful information about which cells are inputs (i.e. other calculations depend on them, but they themselves are not calculated), which cells are workings (i.e. they are calculated, and…
New easy menu system in Rainbow 12.1
We’ve been thinking for a while about how to make it easy to find all Rainbow’s functions, even the ones hidden away under the buttons on the Rainbow tab. And we’ve now found a way to do this with a new easy menu system that works seamlessly within…
Find hidden cells and risky macros
In version 12 of Rainbow we’ve added several new risk analysis options to the Risk Map function. We’ve done this by moving some “mapping” options from the last Risk Map tab across to the Logic Analysis function (see previous post). And…
Clean up phantom links and custom formats
Have you ever had that sinking feeling when a colleague sends you a spreadsheet with the request to “just take a quick look at this”? And you find the spreadsheet takes ages to open, seems to have lots of strange links (although Excel lists only a few on…
Map your spreadsheet structure with Logic Analysis
Have you ever wished for a spreadsheet analysis tool that lets you see at a glance the structure and layout of your spreadsheets? In Rainbow version 12, the new Cells and Data tabs in the Logic Analysis function let you do this very quickly and easily. For a practical…
Usability improvements in Rainbow 11.4
With Rainbow 11.4 our main focus has been on usability rather than new functions. We’ve gone behind the scenes to optimise some of the user interface code, and you’ll now find that Rainbow loads more quickly, and starts individual functions more smoothly…
Corporate integration in Rainbow 11.3.1
With Rainbow 11.3.1 we’ve added some further features that will help Rainbow integrate smoothly into a large-corporate environment. In particular, we’ve given you control over two of Rainbow’s functions (Check For Updates and Uninstall) that could…