Shared Workbook displays different sorting for users

[eXtremer]

Hi all,

I have a issue with a Shared Workbook where 4 users work at the same time. Today when one user opened the excel file the sorting was not correctly shown, while for the other users everything is fine, the sorting is as supposed to be. How to fix the problem for that user ?

*I know that when a shared workbook is opened a temporary file is created and and all the changes are saved there but when you close the workbook all the changes are being saved on the original file. I tried to re-open/close the excel file, logged off/on, still the data is not sorted correctly for one user.

Thank you.

[eXtremer]

Please, anybody ?