Compatibility Problems with pivot table (inserting slicers)

%3CLINGO-SUB%20id%3D%22lingo-sub-1525652%22%20slang%3D%22en-US%22%3ECompatibility%20Problems%20with%20pivot%20table%20(inserting%20slicers)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1525652%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Microsoft%20community%2C%3C%2FP%3E%3CP%3EI%20have%20created%20a%20consolidated%20Pivot%20table%20with%20Excel%202013%2C%20which%20gets%20its%20data%20from%205%20different%20tables%20(none%20of%20them%20shows%20any%20conpatibility%20problems).%20I%20wanted%20to%20insert%20some%20slicers%2C%20but%20instead%20of%20creating%20them%20a%20Pop%20up%20window%20occurs%2C%20which%20says%2C%20that%20one%20of%20the%20PivotTables%20was%20created%20with%20a%20version%20prior%20to%20Excel%202007%20(which%20is%20not%20the%20case%2C%20since%20all%20of%20them%20were%20created%20with%20the%20Version%20from%202013).%3C%2FP%3E%3CP%3EThen%20I%20have%20made%20a%20compatibility%20report%2C%20where%20some%20problums%20occur%2C%20which%20only%20concerns%20Excel%20versions%2C%20which%20are%20from%202007%20or%2097-2003.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20any%20clue%20on%20how%20to%20overcome%20that%20compatibility%20Problem%20in%20order%20to%20insert%20the%20slicers%3F%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3EThanks%20in%20Advance!%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1525652%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Dear Microsoft community,

I have created a consolidated Pivot table with Excel 2013, which gets its data from 5 different tables (none of them shows any conpatibility problems). I wanted to insert some slicers, but instead of creating them a Pop up window occurs, which says, that one of the PivotTables was created with a version prior to Excel 2007 (which is not the case, since all of them were created with the Version from 2013).

Then I have made a compatibility report, where some problums occur, which only concerns Excel versions, which are from 2007 or 97-2003. 

 

Does anyone have any clue on how to overcome that compatibility Problem in order to insert the slicers?
Thanks in Advance!

0 Replies