Our add-in/Risk Detection functionality offers comprehensive risk reports in pdf format at the click of a button. These reports contain information about the size, complexity, and structure of a spreadsheet which gives an indication of the scale of a spreadsheet at a single glance. These reports also provide comprehensive or summary reports on risks found in the model including references to those locations and suggestions for improvement. How comprehensive these reports are is up to the user as they can easily customize the amount of information found in these reports. Gain a comprehensive understanding of the scope and trustworthiness of a model at the click of a button, and gain the ability to share this information with colleagues, clients, or anyone else.
Reports in Excel
The Add-in also offers a report back to Excel, this report can be used to practically work through the risks present in the file. This is a good way to work through risks for some users as the information is presented in Excel which is a familiar environment in which you can work with comments, adjustments, filters, and whatever else users want to do in Excel. In this case a copy of your spreadsheet is generated with a separate tab containing all risks, improvement suggestions, and links to the location where the risk was found.
PerfectXL Compare offers an export to Excel containing a summary of all differences between 2 versions of a spreadsheet as well as the specific details of what the differences are. this can be used just like the add-in report, in other words you can work with the information in Excel. The other advantage of having these differences in Excel is that it can be a great basis for a changelog which can be kept in a separate tab to track what is changing in spreadsheet.
- Avoid >70 types of risks
- Improvement suggestions
- Quality reports
Read more about risks in Excel files
On this page you will find a step-by-step walkthrough of the PerfectXL Risk Eliminator.
Here you will find information like system requirements, release notes, and answers to most questions about our software.
VLOOKUP and the combination of INDEX and MATCH are well known ways to search in Excel, and to our great frustration, VLOOKUP is used a lot more often.
Our software inspects spreadsheets on all kinds of spreadsheet risk. Read more about some of the risks we detect in spreadsheets here.
Excel horror stories are often related to accidentally changing, shifting or changing units or number formats.
Long ago, Excel was not as clever and advanced as today, but the so-called array functions have been around for a long time. However, most people do not know about them, and do not understand them.
(Hidden) circular references occur when Excel tries to compute a result of a cell that’s already been visited during the calculation round. Excel doesn’t warn us of conditional circular references.
Whenever possible, keep your Excel formulas short and simple. Avoid long formulas; they are harder to read, harder to understand, difficult to check and tough to improve.
The use of fixed numbers is a bad idea. A future user will not know where the number came from, and fixed numbers don’t change automatically, and thus might be overlooked when a change is made.
Do not hide anything except some sheets. Excel has too many attractive options that look good but may be risky in the long run.
Sometimes, you need to use the exact same formula, based on the same numbers, in several other formulas. You might be tempted to calculate this formula twice, but resist the temptation. Calculate your formulas only once!
It is so tempting to merge cells in Excel so that they form a header above two or more columns. Yes, we must admit, it looks nice, but resist the temptation because it can be dangerous!
It’s a bad idea to leave standard Excel errors in your workbook. Take the time to clean up, because after a while, you no longer know whether you left a mistake consciously or if there is something wrong with your spreadsheet.
Place a formula close to its input variables. You reduce the chance of mistakes, you make optimal use of Excel’s support, and your spreadsheet becomes easier to carry over to someone else.
To be able to trust a spreadsheet, a thorough check for errors and mistakes is essential. There are lots of different ways a simple mistake can destroy the validity of a spreadsheet.
Good, error-free spreadsheets are essential for using them reliably in business. This is why risk detection is an important aspect of spreadsheet validation.
Excel is a powerful tool. And when it can’t do what you need, VBA can fill the gap. Unfortunately, using VBA can lead to unpredictable behaviour, slow performance, and corrupt Excel files.