Risk detection in spreadsheets is one of the essential features of PerfectXL. Currently the tool detects up to 75 types of risks, ranging from small risks to major problems. In cooperation with the Spreadsheet Department of Delft University of Technology, we keep expanding the list of detectable risks.
7 Risk Categories
The detectable risks are presented to you in 7 main categories: calculation doubts, structure issues, range issues, hidden info, complex formulas, vulnerable functions and VBA Issues.
Excel does what you ask for, but are you asking the right question? We see many formulas that give us reason to doubt that. For example when fixed numbers or double operators are used. We call this category of risks ‘calculation doubts’.Read more about calculation doubts
The creation of a good structure is one of the most important, yet underestimated aspects in the development of a spreadsheet. Usually a spreadsheet starts small, but then it grows and nobody gets around to reorganizing the structure anymore. PerfectXL groups the risks resulting from bad structure under ‘structure issues’.Read more about structure issues
Large spreadsheets are usually stuffed with formulas based on cell ranges. When spreadsheets are edited or expanded over time, different types of range issues may occur. These issues are usually hard to detect, but they can be very risky! We’ve seen big numbers and large sums of money ‘disappear’ because of range issues.Read more about range issues
Sometimes it sounds like a good idea to hide seemingly ‘unimportant’ information from other users. The usability of complex spreadsheets will appear to increase. but this is a deceptive idea. The next user can edit hidden info without realizing it, with many unintended consequences.Read more about hidden info
The art of programming is the art of keeping things simple. Complex formulas are hardly ever wise to use and calculations can usually be simplified. You just have to figure out how. PerfectXL points out different types of complex formulas in your spreadsheet and offers suggestions to improve the complexity.Read more about complex formulas
Currently Excel offers about 475 standard functions and new ones are added regularly. Most of these functions are rock-solid, but we consider a couple of them to be ‘vulnerable functions’. Some of them are frequently used by many Excel professionals. We suggest you try to avoid using them. Excel offers a range of fine alternatives.Read more about vulnerable functions
xRead more about VBA issues