I have a computer that has an i7 processor (4th generation), 8GB of RAM and an SSD drive.
Excel 2013 is very, very slow with apply a filter and unfiltering.
I've tried the filtering and unfiltering the same spreadsheet on machines with much lower specs and it works much faster.
On this same machine, I've installed Excel 2010 and using the same spreadsheet it filers and unfilters in seconds, vs 3+ minutes.
I've uninstalled, reinstalled, installed Excel 2016 and all of these come up with the same slow results.
I've set the computer to optimize for program performance. I also changed the advanced display feature in Excel to "Disable hardware graphics acceleration", removed the check for "Automatically Flash Fill".
I've tried so many things and it just isn't working correctly on this computer. I know it's not the spreadsheet because the sheet filters fine on other computers. and Excel 2010 works great on this computer.