Excel Forum

Slicer

Madi

India

Member

Members

Forum Posts: 63

Member Since:
December 8, 2017

Offline

August 21, 2018 - 3:42 pm

Hi all

i don't know how to create Slicer in table, could you help me to how to do

Thanks/Saliha

Philip Treacy

Admin

Forum Posts: 1614

Member Since:
October 5, 2010

Offline

August 21, 2018 - 4:11 pm

Hi Mohamed,

Have you read though our blog articles on slicers?

Start with this https://www.myonlinetraininghu.....licer-that

Regards

Phil

Madi

India

Member

Members

Forum Posts: 63

Member Since:
December 8, 2017

Offline

August 21, 2018 - 4:28 pm

Hi Phil

Thanks for your immediately reply, i have checked above link and i have try in my datas but slicer option not enable.

could you please help to solve this, please see the below screen short for your reference.

Thanks/Saliha

Attachments

Slicer.jpg (83 KB)

Anders Sehlstedt

Eskilstuna, Sweden

VIP

Members

Trusted Members

Forum Posts: 929

Member Since:
December 7, 2016

Offline

August 21, 2018 - 6:07 pm

Hello Mohamed,

As per your picture, the problem is because you are working whith an .xls file in compatibility mode. Slicers are not supported in .xls files. You need to convert your file to new file format having .xlsx as extension. You can read more about it in below link.

https://support.office.com/en-.....cfd651a5ac

Br,

Anders

Madi

India

Member

Members

Forum Posts: 63

Member Since:
December 8, 2017

Offline

August 21, 2018 - 8:25 pm

Thanks you very much for support

Madi

India

Member

Members

Forum Posts: 63

Member Since:
December 8, 2017

Offline

August 23, 2018 - 3:02 pm

Please help to solve this error

regards/saliha

Attachments

slicer-error.jpg (123 KB)

Anders Sehlstedt

Eskilstuna, Sweden

VIP

Members

Trusted Members

Forum Posts: 929

Member Since:
December 7, 2016

Offline

August 23, 2018 - 9:35 pm

Hello Mohamed,

Please explain with details what the issue is, as I can't see any. I assume you expected to see some data connections, but if no data has been imported you don't have any connections. Even if data has been imported some time, the connections can be deleted.

Br,
Anders

Madi

India

Member

Members

Forum Posts: 63

Member Since:
December 8, 2017

Offline

August 23, 2018 - 10:01 pm

Hi Anders

just i analyst i have a data but i am not convert in to table, its working now after i use table.

Thanks for reply