Category Archives: News

Sharing Rainbow reports in version 11.3

Sharing Rainbow reports in version 11.3

Rainbow users have sometimes asked me whether it’s OK to share Rainbow reports with colleagues who don’t have Rainbow, or whether you need to have Rainbow installed in order to view the reports.

The short answer is that Rainbow reports are simply Excel worksheets, and they can be shared with anyone who has Microsoft Excelâ„¢ installed. However, there’s also a longer answer, because most Rainbow reports contain buttons (such as the Help button on the right of the composite screenshot above) which call on part of the Rainbow program code, and clearly these buttons won’t work for someone who doesn’t have Rainbow installed.

Occasionally there can be a problem even if you send a Rainbow report to a colleague who also uses Rainbow, if they have a completely different version of Rainbow from you (e.g. Rainbow Governance rather than Rainbow Professional), because the report won’t find the Rainbow add-in file that it’s looking for.

So in version 11.3 we have added a small function called Toggle Rainbow Links, which enables you to remove and/or add back a Visual Basic link to Rainbow, if for any reason you find yourself with a Rainbow report where the link isn’t working. As shown in the composite screenshot above, this function will first confirm whether or not a link exists, and then allow you to add or remove it.

And of course if you’re sending a Rainbow report to a colleague who definitely doesn’t have Rainbow, you can (if you really want to) simply remove the buttons; just right-click on each button, then select Cut.

Quickly undo changes with Rainbow 11.2

Quickly undo changes with Rainbow 11.2

Rainbow has offered an Undo Changes function for many years, and we made it much more visible in the recently redesigned menu (in version 11.0). However, as you probably know, it was only able to operate if you had already used the Save Format function to create a “format restore point” to which Rainbow could… Continue Reading

Fix merged cell problems with Rainbow 11.1

Fix merged cell problems with Rainbow 11.1

If you ask any professional Excel developer about merged cells, they will almost certainly say something that can’t be repeated here! Merged cells can produce incorrect calculation results, prevent sorting and filtering in data tables, cause errors in macros, and waste large amounts of time when spreadsheets have to be updated. Of course if your… Continue Reading

Manage all your spreadsheets with Rainbow 11.0

Manage all your spreadsheets with Rainbow 11.0

You may have already noticed that with the release of Rainbow version 11.0 there are now two editions of Rainbow that you can download from our Home page: Rainbow Analyst Professional (Rainbow Pro) and Rainbow Governance. And if you download Rainbow Governance after having used an earlier version of Rainbow Pro, you will immediately see… Continue Reading

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… Continue Reading

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

Back to topAdministration