ExploreExcel

ExploreExcel lets you analyse an MS Excel spreadsheet/workbook and report on it
Download

ExploreExcel Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Free to try
  • Publisher Name:
  • GWAcc Limited
  • Operating Systems:
  • Windows
  • File Size:
  • 1.7 MB

ExploreExcel Tags


ExploreExcel Description

ExploreExcel is an application 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 Requirements: ■ NET 2 Runtimes, MS Access 97-2003 Limitations: ■ saving output, drill-down


ExploreExcel Related Software