All rights reserved.How to convert a Microsoft Excel slicer into a series of filtering buttons on a PivotChart Important Note: If you are using Excel 2013 (not Office 365 version), then you need to make sure that your computer was updated to at least Office 2013 Service Pack 1 (SP1).Ĭopyright (c) 1997-2021, VidasSoft Systems Inc. Make sure that check box by "Microsoft Office PowerPivot for Excel 2013" is checked and then click OK. At the bottom of the screen from "Manage" drop down list select "COM Add-ins" and click "Go." button. For that you have to start Excel 2013, click on menu item "File" then "Options", then click on tab "Add-In". If you have Excel 2013 edition that has full PowerPivot support, you do not need to install PowerPivot add-in, but you might need to enable Power Pivot. If you will keep external data files in preconfigured location, then Portfolio Slicer will work on most Excel 2013 versions (except starter). Portfolio Slicer needs full PowerPivot support just if you want to change location of Portfolio Slicer external data files. For subscription based office, just Office 2013 Professional Plus edition has full support for PowerPivot. But if you bought Excel 2013 from retail store, then you do have full PowerPivot support. For example, if you bought Office 2013 from retail store, then you do not have full PowerPivot support. Without full PowerPivot support you can use PowerPivot applications (like Portfolio Slicer), but you cannot view and edit existing model. With full PowerPivot support you can start PowerPivot window and view and change existing PowerPivot model.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |