Pivot table slicer feature not working in macro enabled file

SnumSnum

New Member
Joined
Nov 15, 2017
Messages
8
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?
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Watch MrExcel Video

Forum statistics

Threads
1,099,005
Messages
5,465,959
Members
406,456
Latest member
jmishra91

This Week's Hot Topics

Top