Formulas in spreadsheets are the source of most errors. Long formulas can also be difficult to comprehend. So the ability to be able to find, analyse and break them down into understandable sections, to see how they are used and to be able to detect errors is critical.
We provide two tools to help Excel users create more reliable spreadsheet:
Formula viewer: An add-in to ComplyXL that allows you to explore the formulas in your spreadsheet. Formula Viewer is part of the Desktop, Professional and Enterprise editions of ComplyXL
Bounds Checking: Part of ComplyXL that gives the user the ability to zoom into changes outside an expected range
Spreadsheet Detective: Detect potential spreadsheet calculation errors and document workbooks
Contact us
For a trial license for the Formula Viewer, Bounds Checker and Spreadsheet Detective click here or contact us on (US) 1-800-401-0289 or (EU) +44 027 043 2777. If you are looking for specific functionality not shown here, please call for more information.
Formula viewer
Benefits include:
Complex formulas broken down to help reduce the likelihood of errors
Help you understand the complex formulas created by other users
Display formulas in a structured way showing each part of the formula or function
Display is updated dynamically as you explore cell formulas and drill into the formulas of dependent cells
History list shows the path of your review so you can jump back at any point
Another way to review spreadsheets is to use ComplyXL Bounds Checking. This facility gives the userthe ability to filter and identify changes to numeric cells which are specified by a user defined interval. This ability means the user can focus in on cells which fall inside, are above, below or outside the interval's upper and lower bounds.
Enterprise Frontpage
ComplyXL 