|
Description
ExploreExcel is a software product designed to make the job of documenting your spreadsheet and helping to correct any errors as simple as possible. ExploreExcel handles any spreadsheet which Excel can import (created by Gnumeric, Open Office, etc.). Information Provided Excel - Version, Add-ins, options, etc. Workbook - Who created it, when, number of worksheets, charts, etc. Worksheets - Name, extent, hidden rows, hidden columns, visibility, protection, consolidations, circular references etc. Cells - Displayed, formula, conditional formulae, formatting, array formulae, links to and from other cells, etc. Charts - Name, data range, chart type, etc. Errors - What they are and where they are Named Ranges - Name, range, location External links - From where, to where Comments - All commented cells and the comment Code behind - Any VBA code modules and if possible the code Pivot Tables - Name, location, source data, page fields, column fields, row fields, data fields Scenarios - Name, location, changing cells Formula Arrays - Location, formula, cells used Functions - What built-in and user functions are used and where Objects - Shapes, location, type The freeware version is limited in certain aspects, like as saving output, drill-down etc.
|
