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 GernDog. Your suggestion to use Word's File --> Options --> Save --> Caching Options. Checking the box " Delete files from the office document cache when they are closed" and then pressing the "Delete" button ............brought to a successful conclusion 6 hrs of stumbling around by me. I had a Microsoft Access application that created a Word Doc from a .dotx template. For some reason -- apparently caused by the template when creating a "new" Word doc, finding a cached version that was a .doc, not a .docx. This seemed to somehow -- when the VBA code was using this .doc to save it as .pdf, so as to attach the.pdf to an Outlook email -- trigger a message from Microsoft saying "This file type doesn't support Microsoft Information Protection", and the .pdf was not created. I don't really understand why the "File --> Options --> ...." set of choices mentioned just above .... seems -- after quite a few now always successful tests -- to have solved the problem. By "solving" I mean that opening the .dotx Word template, ever after that above-mentioned set of instructions was issued and its final "Delete" button clicked, create a .docx file rather than apparently open a cached .doc file. Then the subsequent instruction from the .docx file to save itself as a .pdf succeeded. Previously, in at least a dozen tests with carious workarounds, it had always failed.
Thank you.
Thank you.