3

I have recently started experiencing a weird bug with excel, for some reason it has stopped sorting columns. It does not matter the way I try to sort, it just does not do it, however, filtering does work.

I have been googling for over an hour but the issues I found do not seem to be similar to mine, and I have tried sorting in any simple way I know:

  • HOME > Sort
  • DATA > Sort
  • Selecting the column > right click > sort
  • Making a table from a range > click on the filter > sort

Note that this happens in a blank new spreadsheet with manually entered data, no files downloaded from the internet or generated from any other software. I went as far as re-installing Office without success. Nevertheless, if any of the explanations above are unclear, you can appreciate in the following gif my issue.

Window Recording - Excel

If any of you have any pearls of wisdom, I would really appreciate it.

Mokubai
  • 95,412
EOZyo
  • 31

2 Answers2

0

For me, removing my user account from the PC and recreating a new one solved the problem. I also had the situation that everything worked in safe mode and I tried a few re-installations but I had no success. Removing my account helped.

Chaos_99
  • 1,008
Ljuba
  • 1
0

I had the same issue with Excel 365 on Windows 10 and I was able to sidestep this issue by wiping out Office installation completely - firstly with the official office extermination tool from this guide, than cleaning up remainings manually according to this guide. I haven't verified it, but I believe that HKEY_CURRENT_USER\Software\Microsoft\Office registry subtree is the real crux and it's removal before the reinstallation was what finally fixed it for me without the need to recreate the account.

zeronineseven
  • 1