Wasim Akhtar

Database Architect, Designer and Developer
My motto: If you can explain it to me, I can develop it for you!
For a QUICK development summary, please look at SCREENSHOTS under Recent Applications!
Skip Navigation Links.
Copyright © 2000-2018
Practical Software Solutions

PSS Logo

Website Updated
15-Nov-2018
 
 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:

Menubar Data Form Form & PivotTable
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