About this tutorial:
Video duration: 4:52
Visit this page for written instructions, and more Slicer videos.
Slicers were introduced in Excel 2010, and they make it easy to change multiple pivot tables with a single click.
To make older pivot tables work with Slicers, you’ll need to update the files to the newer Excel formats — xlsx, xlsb or xlsm.
Occasionally a pivot table isn’t recognized by the Slicers, even after updating. You can create a new pivot table, or try to repair the old one.
Watch this video to see how to update the files, connect to Slicers, and repair a…