Lyquidity provides Workbook Statistics and analytics to help visualize spreadsheet risk.

Monday, 02 June 2008 22:27

London, New York, Sydney, Immediate Release: Lyquidity Solutions, www.lyquidity.com, providers of ComplyXL for enterprise spreadsheet management, today releases free Workbook Statistics and spreadsheet inter-dependency analyzer to help organizations report and visualize the risk characteristics of their spreadsheets.  Regular use should improve the quality of spreadsheets used across an organization.

The statistics and dependency analyzer is an add-in for Excel that allows an organization to analyze workbooks, to collect statistics, calculate risk weightings and to generate dependency diagrams for all spreadsheets.

The add-in produces a comprehensive report that is very quick to generate, even workbooks containing millions of cells take only a few seconds to analyze.

“Excel has all the functionality needed to analyze its own workbooks” said Sandy Marshall, Product Manager at Lyquidity Solutions, “it just needed to be presented in a useful way.

We are aware that companies using spreadsheets are being charged significant sums for software claiming to provide the type of analyses that Excel is able provide.

As it took us just a couple of days to produce this tool for a client and because it will be of benefit to all organizations, we felt that it would be great to offer it as a free download.

We have used Excel’s VBA and the rich functions Excel provides to create the add-in.”

The Workbook Statistics add-in takes advantage of the VBA facilities Excel provides to make it easy to present details such as the number of formulas, cell types, errors, hidden information and external links.

The add-in uses these and Excel’s ability to create rich reports

and diagrams.

Spreadsheet Statistics can be downloaded from our site here www.lyquidity.com/freeaddins/.



The add-in is unlocked so user organizations can customize it to meet their requirements.

The add-in provides:

Cell use and error review, the ability to assign a risk weighting to each cell, dependency analysis and diagram, highlight potentially broken and invalid links such as circular relationships.

Lyquidity’s main product, ComplyXL Enterprise, adds value to Excel by offering spreadsheet management and control to aid the compliance process for organizations.

ComplyXL provides:

Version control - what changes have been made to the spreadsheets and what were theyChange control - who made the changes, whenAccess controls for spreadsheets – user rights for spreadsheets defined, from simple compare rights, through to full manager rightsBI style reporting for Sarbanes Oxley compliance – strengthening the transparency for the audit process, documentation easily producedFull history of spreadsheets – available as an audit trail, available for reporting purposesSnapshot facility – what comparisons were carried out, using which criteria, etc formulas, arrays, macros Spreadsheet discovery – automated to find spreadsheets wherever they are, as often as you specifyInstant notification of changes to spreadsheets – whether via email, or IMComplyXL seamlessly links in to SharePoint

For more information, please visit our website at http://www.lyquidity.com or contact This e-mail address is being protected from spambots. You need JavaScript enabled to view it to arrange a web demo.

Lyquidity has made available full presentations showing all aspects of ComplyXL to give users a deeper understanding of the software and how it can be used and deployed.

Full presentations of ComplyXL and its capabilities are available at www.lyquidity.com/demonstrations

Pricing is also shown on the website at www.lyquidity.com/pricing

Enterprise solutions available for under $10,000

About Lyquidity Solutions

Lyquidity Solutions is a privately held, leading spreadsheet management software company providing corporations worldwide with compliance tools to ensure corporate governance.

With technology for full spreadsheet control and management Lyquidity provides solutions to organizations across market sectors from banks and finance through to airlines, consultants and healthcare around the world.US inquiries please call 1-800 401 0289, and for European enquiries please call: +44 (0)207 043 2777 or email This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Media contacts should be addressed to This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Excel and SharePoint are trademarks of Microsoft Inc.