Home

Slicer limitations

%3CLINGO-SUB%20id%3D%22lingo-sub-565621%22%20slang%3D%22en-US%22%3ESlicer%20limitations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-565621%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20Expanding%20Data%20Range%20from%2053%2C000%20to%2063%2C000%20rows%20on%20an%20existing%20Pivot%20table%2C%20it%20looses%20connectivity%20to%20the%20Slicer.%20does%20the%20slicer%20have%20a%20limitation%20on%20data%20range%2F%20rows%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-565621%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-567244%22%20slang%3D%22en-US%22%3ERE%3A%20Slicer%20limitations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-567244%22%20slang%3D%22en-US%22%3ENot%20that%20I'm%20aware%20of%2C%20so%20when%20you%20add%20more%20data%20and%20refresh%20the%20Pivot%20the%20slicer%20no%20longer%20works%3C%2FLINGO-BODY%3E
Peter_Licovski
Occasional Visitor

When Expanding Data Range from 53,000 to 63,000 rows on an existing Pivot table, it looses connectivity to the Slicer. does the slicer have a limitation on data range/ rows?

1 Reply
Not that I'm aware of, so when you add more data and refresh the Pivot the slicer no longer works
Related Conversations
AIP limitatations with groups
Stefan Nordberg in Azure Information Protection on
0 Replies
Data Slicers not working properly with Excel 2016
LordRA in Excel on
2 Replies
can you add a Macro Button based on Slicers?
icorte in Excel on
2 Replies
Slicer for Dates
Chris Sanders in Excel on
4 Replies