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.). Below is a basic list of some of the information provided.
It provides information about worksheets, cells, links, errors, possible security risks and much, much more!
Main features:
-Excel - Version, Add-ins, options, etc.
-Workbook - Author, Worksheets, Charts, etc.
-Worksheets - Name, Extent, Hidden Rows, Protection, Circular References etc.
-Cells - Displayed, Formulae, Conditional Formulae, Array Formulae, Links etc.
-Charts - Names, Dates, Ranges, Chart Types etc.
-Errors - What and where
-Named Ranges
-External Links - From and To
-Comments
-Code Behind - Any VBA code modules and the code, if possible
-Pivot Tables - Name, Location, Source Data, Page and Column Fields etc.
-Scenarios - Name, Location, Changing Cells
-Formula Arrays - Location, Formula, Cells Used
-Functions - What built-in and user functions are used and where
-Objects - Shapes, locations, types.
Comments