Excel for Mac does not support PowerPivot and Pivot Charts Any pivot table having source data based on the Excel Data Model will be unfilterable if theDefine name manually To define a name to a range you can use shortcut CTRL F3 Or you can follow these steps Go to Formula On the Formula tab, in the Defined Names group, click Define Name Or, press Ctrl F3 to open the Excel Name Manger, and click the New button Either way, the
Use Dynamic Range Names In Excel For Flexible Dropdowns
