Excel for the web supports slicers ... right-click the slicer and click Refresh. Doing so will force the buttons to sort and they will pick up the new custom sort, as shown in Figure F, that ...

5. In the final step, click on the “Close & Load” button in the Power Query toolbar to apply the changes and load the data back into Excel. To refresh Power Query automatically when the source ...