Latest Updates

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…

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…

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…

For 12 years Rainbow didn’t have an installer; you had to install the add-in file (RainbowPro.xlam) yourself, which in fact you can still do. Then in 2013 we realised that not all spreadsheet users are techie types, and so we used some proprietary third-party…

Most of us know that sinking feeling of looking at an old spreadsheet where the sheets or the workbook structure are password-protected, and realising that we have absolutely no idea what is the correct password! And if you can’t unprotect some or all of the…

In Rainbow 12.2 we’ve focused on spreadsheet calculations, with two new features. One gives you precise control over how you run calculations, and the other lets you see how calculations are repeated throughout a spreadsheet. The new Calc Manager function lets…

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…

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…

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…