Works with Microsoft® Excel® 2003, Excel 2007, and Excel 2010 (32-bit and 64-bit versions)
With Excel 2010, Microsoft introduced something it calls a slicer. This
is an independent object that acts as a filter for a PivotTable (and its
associated PivotChart, if any). TM Retro Slicer enables some of the
features of a slicer in older versions of Excel particularly Excel 2007 and
Excel 2003. For example, Figure 1 shows a PivotTable shows the number of
scans done only for specific technologists (those whose names appear in a
blue background in the slicer).
Figure 1
A PivotTable can have multiple slicers filtering data in it. Also, the slicer object is customizable in terms of the number of columns used to show the item values. For example, Figure 2 shows the PivotTable filtered to show data for all technologists other than Cassandra and to show data only for CT and Pet scans.
Figure 2
While Excel supports filters for pivot fields, the UI is less that friendly. The Slicer UI, on the other hand, is very easy to understand and use.
One feature that Excel does not support natively is filtering data on fields not present in the PT. The 2010 slicer enables this capability. With TM Retro Slicer one can also add a slicer for an element not present in the PivotTable. However, to make the slicer work correctly, the add-in will add this element as a page field in the PT.
Figure 3 -- An Excel 2003 PivotTable before adding slicers for fields not
already present in the PT
Figure 4 -- After adding slicers for fields not already present in the
PivotTable;
the add-in adds these fields as page fields
Download either the self-installing version or the zip version.
Download sample workbooks for 2003 and earlier or 2007 and later.
Please check the help file, the documentation, and the webpage for the product, template, or service you are interested in first. If you still need help, please email web-underscore-contact-at-sign-tushar-hyphen-mehta-dot-cee-oh-em.
Microsoft has recognized my technical excellence, contributions to various communities, and independent expertise with the Most Valuable Professional (MVP) for Excel annual award for ten years in a row from 2000 to the present.
Please contact me for world-class solutions that integrate the most appropriate business practices and technology to resolve your problem. You can email me at web-underscore-contact-at-sign-tushar-hyphen-mehta-dot-cee-oh-em.
To return to the Microsoft® Office Marketplace from this page, click the BACK button.
To return to this page from any link on the page, just close that window
Unless noted otherwise none of the products downloadable from this website is endorsed by, supported by, or produced by the Microsoft® Corporation.
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
