When using a filter, the collumns of the sheet that has been locked from scrolling was permanently connected to the rest of the dokument. Refiltering in other ways still affects the entire sheet as normal, only with the difference that the order is wrong. The sheet is a list of apartments and their respective owners and now the names A-Z now corresponds to appartmens 1-100 (which is of course all wrong).

I'd be more than happy for a helping hand, Simon Farsi