I have a pivot table that will not allow me to add a slicer. I originally had it saved as a .xlsx file but have tried saving it as .xlsm as well. It just keeps telling me that one of more of the pivot tables was created in a version of excel prior to 2007. I use excel 2016 and so did the person who created the original data file. Is there any way to save it as something else that will allow me to use slicers? Or does anyone know what could be creating the error? Like if we copied a report template from an older file but filled in new data would it have saved as a previous version of excel?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Pivot table slicer feature not working in macro enabled file
- Thread starter SnumSnum
- Start date
