Excel 2013 Inquire first looks

The Inquire Addin is better than nothing, but it seems to be only useful for small spreadsheets.

For example, the Workbook Analysis Report lists all formulas individually, with no concept of how the same formula in relative terms has been copied over areas. I find it hard to believe that such a list would have been accepted as useful in a commercial product.

The worksheet relationship diagram provides little useful information

Worksheet Relationship Diagram

The Cell relationship diagram tries to draw an arrow for every precedent cell including those in a LOOKUP block: again, not very useful:

Cell Relationship Diagram 7350 nodes

I can’t see this replacing XLTest or any other decent commercial spreadsheet auditing package. However, if it gets users aware of the bad smells which the Workbook Analysis Report lists, they may become aware of the need to look further, which is good.


About Patrick O'Beirne, Excel/VBA developer

Patrick provides consultancy and training in spreadsheet automation, data analysis, testing and model review; and the Excel spreadsheet auditing addin XLtest
This entry was posted in Risk, Software Quality, Software Testing and tagged , , . Bookmark the permalink.

1 Response to Excel 2013 Inquire first looks

  1. My eusprig paper on the full list of issues with the Inquire add in is at

    Click to access excel-2013-inquire-add-in-review.pdf

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s