Forum Discussion
Excel App opens old Version of document saved in Sharepoint Online
I am not quite sure if It's a sharepoint online or an excel problem. If I open the excel document with the online excel version, it will show me to correct last saved version of the document. If I op...
This resolved the issue for me. I had to open another Excel file to do this and save, since my messed up file could not be saved.
https://www.mrexcel.com/board/threads/working-from-sharepoint-cache-issue-discard-changes-fix.1163214/
Here is the text from the post.
"Hi Luke777, hope your issue had got resolved. I had faced exactly the same issue. It needs Office Document Cache to be cleared in order to fix this which is available from File --> Options --> Save --> Caching Options. Checking the box " Delete files from the office document cache when they are closed" fixed this issue."
Thank you for sharing. This has been bugging me for AGES, I just had another Friday afternoon look to see if I could find a solution, much appreciated!!!