[Solved] Slicer not active in excel sheet 2010

[ravio]

while opting for slicer option it is showing no connection found. Any idea?

 

[Lutfor Rahman Shimanto]

while opting for slicer option it is showing no connection found. Any idea?

Hello Ravio

You are welcome to ExcelDemy Forum, Ravi! Thank you for reaching out and sharing your queries. You mentioned that you are using Excel 10. While trying to use the slicer option, it is showing no connection found.

In older versions of Excel, such as Excel 2010 and earlier, slicers are not natively supported. If you use Excel 2010 and need slicer-like functionality, you must rely on traditional filters. However, starting from Excel 2013, slicers were introduced as a new feature.

I recommend you to visit some articles that may help you understand the problem you are facing.

• Excel Slicer Greyed Out​
• Excel Pivot Table Slicers: All Things You Need to Know​

Thanks once again. Stay in touch with the ExcelDemy Forum.

Regards
Lutfor Rahman Shimanto