This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am using Win 10 - Microsoft excel 2010
I have data and already convert it to table. I want to slice it, but when I choose the "Slicer" button, only a gray table appears, notifying that there are no connections on my worksheet or computer.
I have searched for help but cannot find the answer.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
That Slicer in 2010 works for Pivot Tables and CUBE functions only.
The Slicers button you expect is available in 2013 and above in the Table Design tab.
Andreas.
Thank you, Andrea.
I was so confused, because according to this link: https://support.office.com/en-us/article/use-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-12651785d29d, it says that the slicer function could be applied on Excel 2010 and even instructs me to convert my data into table to use it.
https://support.office.com/en-us/article/use-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-12651785d29d, it says that the slicer function could be applied on Excel 2010 and even instructs me to convert my data into table to use it.
Yes, the article is a bit misleading, but it's still valid ... but only for a Pivot Table which support Slicers in Excel 2010.
Andreas.