|
Pivot Table Tools |
|
Purpose |
Tools to manage Pivot Tables in MS-Excel
|
|
Screens |
To view a few key screenshots from this MS-Excel application, please click on the following links:
|
|
Description |
For analyzing data
In MS-Excel, Pivot Tables provide an
easy to use interface that most users can master very quickly. However, PivotTables
have several limitations that reduce their usefulness; such as, non-editability
of data, lack of ability to recal previous PivotTable format, and frequent resizing
of columns and rows.
These tools help overcome some of these limitations of PivotTables, including retrieving
complete text of 'Memo' fields that are truncated by MS-Excel at 256 charcaters. |
|
Features |
Following are some of the key features of this application:
- Display Current Row's Data in a Form View
- The Data Form Allows Insert, Update & Deletion of PivotTable Data
- Current Data Form Record is Highlighted in the PivotTable
- Dropdown Lists of Fields in the Data Form are Populated to Allow Quick Data Entry
- Ability to Set Column Width & Wrap Text Properties by Column Names
- SAVE 'Orientation', 'Position' and 'Column Width' of any PivotTable
- RESTORE 'Orientation', 'Position' and 'Column Width' of any PivotTable
- Highlight all Cells that Match the Content of the Current Cell
- View Database and PivotCache Properties
- Highlight the Hierarchy of the Current Cell
- Show or Hide Primary and Foreign Keys
|
|
Components |
This application comprises of the following main components:
- Set Column Width
- Copy to New Worksheet
- Store PivotTable Format
- Restore PivotTable Format
- List Database Info
- List PivotCache Info
- Find Matching Records
- Highlight Heirarchy
- Show Primary/Foreign Keys
- Hide Primary/Foreign Keys
- Refresh PivotTable
- Create Base Data Form
- Create Full PivotData Form
|
|
Technology Used |
The following software development tools and services were used in this application:
- Integration Service: Microsoft Excel 2003+
- Front-End: Microsoft Access 2003+
- Database: Microsoft SQL Server 2005
|
|
MS-Access, MS-Excel and MS-SQL Server are the Registered
Trade Marks of Microsoft Corporation |