Find more hidden errors with Rainbow 10.1

Find more hidden errors with Rainbow 10.1

Rainbow has always been about finding hidden errors, and version 10.1 introduces a new analysis option (in Risk Map and Formula Scan) that detects error values lurking hidden in your IF() statements. A simple example would be where cells B3 and B4 contain the value 0, and B5 contains the formula “=IF(B3>0,B3/B4,0)”. In this case the formula element “B3/B4” in cell B5 contains a lurking #DIV/0! error, which is not currently visible simply because at present the condition “B3>0” happens to be false.

As you can see in the screenshot above, the new “Hidden error values” function gives you a table of all such errors, showing exactly the relevant section of the formula (“B3/B4” in the previous example) and the error that it would generate. And in making space for this new function, Rainbow has not lost any of its flexibility in analysing hard-coded numbers; the different options are now available via your Preferences settings.

Version 10.1 also incorporates a wide range of other enhancements, including:

  • When you try to run an analysis function on a Rainbow report sheet (instead of the main workbook), automatic detection and switching to the reported-on main workbook.
  • A configurable limit to the number of dependents shown in Cell Inspector, to stop it taking forever on a cell that has thousands of dependents.
  • In Names Manager, the ability to find defined names buried in data validation and conditional formatting.
  • In Format Editor, the option to set cell colours to the default “No Fill” and font colours to “Automatic”.
  • Improved Log File viewing, and hyperlinks that work even on unsaved workbooks.
  • Restructured User Guide that should make it easier to find the function you’re looking for.

So why not start the New Year by downloading a free trial of this new version of Rainbow?!

Rainbow 10.0 adds perpetual licence

Rainbow 10.0 adds perpetual licence

For Rainbow 10, we’ve responded to requests from a number of users for Rainbow to include a perpetual licence. So all Rainbow version 10 licences will now allow you to continue using the same version of Rainbow even after the licence period has expired (but you will not be able to install any updates released… Continue Reading

Rainbow 9.3 for Excel 2016

Rainbow 9.3 for Excel 2016

Microsoft have always said that VBA (the language in which Rainbow is written) will be supported for the foreseeable future. However, it’s not uncommon for there to be a few teething problems with the VBA implementation in a major new release such as Office 2016. This happened with Office 2010, where there was an issue… Continue Reading

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

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

Back to topAdministration