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).