Forum Discussion
My excel document properties keep reverting when I save the file
So following discussions with several tech help all the way to Microsoft, we have found how this is happening but still not sure why and 2 work arounds for until Microsoft resolve what it is.
So we found that for some reason if you edit the properties/metadata then open the file, it seems to open the version which is sitting in your cache which is not necessarily the current version and therefore when you update things on it and save, it overrides the metadata to whatever is in the version you opened. With the Microsoft tech, we checked and could not find a reason why if you open a file directly to the app, it doesn't use the latest version of the file (although the content within it are up to date). This may be due to the change Microsoft is currently doing with removing/retiring Upload Centre but we aren't sure.
The work arounds we found that worked were:
1. Open in browser mode only as this seems to retain the latest metadata
2. Open the file on the App, don save, simply close it again. Then re-open and this seems to then pull through the latest metadata too.
So still no fix but hopefully this saves someone some time. (If I made any sense at all).
2 years later and still unchanged for this recurring issue between Excel and SharePoint. (Not sure about the other office programs but I did see one about PowerPoint doing same with SharePoint.) My issue, specifically, is due to file naming. Simply adding a hyphen (-) to file name tells SharePoint it's a new file and it works fine but taking the - out and it thinks it's the old file once again. (I've already deleted the file from the SharePoint document library AND the SharePoint Recycle Bin too yet still SharePoint opens old file simply due to somehow remembering file data, that was deleted completely, from the file name itself.)
It is extremely frustrating... and counterintuitive for this seemingly simple fix to be an issue 2 years after first reported (on here at least).
Lastly, please stop using "So" to start your paragraphs/sentences, it's lazy at best, patronizing at worst to the reader.
