Excel desktop sharepoint online file mismatch "Refresh recommended" cant discard changes

marinuspietersimon  Hey, i'm a bit late since this is from 2022 but I might have found an easy fix that will help since this subject has had many views and none of the replies in other forums seem to have an easy solution to this.

I ran into the exact same problem at work and I fixed it by doing this :

Go into the Excel app => file => Options => Save => tick "Delete files from the Office Document Cache when they are closed".

Many replies to other threads suggest to delete Excel's cache and since this checkbox makes it so It's deleted every time you close Excel it should resolve the issue. I've tested it and now the "REFRESH RECOMMENDED" message does not appear anymore. You may need to discard changes one last time on the document you opened just before using this fix tho. 

Hope this helps,

Louis