Slicer connection options greyed out

[nparsons75]

HI, When inserting a slicer from a table, the option to select report connections is greyed out. My worksheets are not protected.

Thank you, apologies if this is a simple one....

UPDATE

This only happens when inserting a slicer from a table, not a pivot table

 

[GJSBED]

Turn your table into a pivot table.

 

[nparsons75]

Wow, never thought about that, can i turn any table into a pivot table?

 

[nparsons75]

How would I turn my table into a pivot table?

 

[RoryA]

A pivot table is a summary of its data, whereas a table is the raw data itself. You cannot use 'report connections' with a slicer attached to a regular table.

 

[nparsons75]

Ah I see. Im trying to find the best way to create a dashboard using data from a table. However I need pivot tables to do so I think.