Version 3.0 - ScanXLS 2007 - released April 2007
ScanXLS assists you in IT audit compliance projects related to internal controls on risks in end user development of spreadsheet models. This inventory/catalog utility has now been enhanced with complexity metrics to address concerns in Sarbanes-Oxley (SOX) 404 audits.
Further information on Product website
Purpose
ScanXLS gives you data for these fundamental questions you need to answer in your Sarbox project:
- What spreadsheets do we have where on the network?
- Who is the responsible owner/user/developer?
- How big are they, how complex, have they errors?
- What dependencies/links exist between them?
- Has a spreadsheet changed from an authorized/validated version?
It scans any given directory and below and obtains a list of all the .XLS files. You then select some or all of these, and it opens each one in turn read-only and reports on some file properties, attributes, the presence of unusual features or settings that may represent a risk or are prone to human error, Excel's error checking summaries, a list of other workbooks that it depends on through links, and a scoring on how 'problematic' it might be. SCANXLS can also compare two workbooks to check whether their formulas and/or values are identical.