SOLVED

Unable to add Slicer

Copper Contributor

I have a workbook with multiple tabs. Most of the tabs I have a slicer using the data in the table, not pivot tables. One of the worksheets will no longer allow me to add a slicer, even though it was there before. Any ideas? When I select Insert and then Slicer on this tab, the dialogue box doesn't give me the options that the other tabs do. It just shows Connections in this Workbook vs the filter options. Please help! I use Microsoft 365

 

 

5 Replies
Is the range still a table?
Yes, it's just text in a table
best response confirmed by kvkey82 (Copper Contributor)
Solution

What's the name of the table?

 

If you're active in a table, you'll see Table Design appear in the ribbon like this:

 

Patrick2788_0-1667841786585.png

 

This worked!!!!! Thank you so much.
You're welcome. Glad it worked!
1 best response

Accepted Solutions
best response confirmed by kvkey82 (Copper Contributor)
Solution

What's the name of the table?

 

If you're active in a table, you'll see Table Design appear in the ribbon like this:

 

Patrick2788_0-1667841786585.png

 

View solution in original post