Microsoft Excel won’t sort the buttons automatically — it isn’t a dynamic feature. To get the buttons to update the sort order, right-click the slicer and click Refresh.

Getting Started with Power Query. 1. Open Excel and ensure that the Data tab is visible. If it is not, you can enable it by going to File > Options > Customize Ribbon and checking the Data box.