My excel document properties keep reverting when I save the file

%3CLINGO-SUB%20id%3D%22lingo-sub-2826913%22%20slang%3D%22en-US%22%3EMy%20excel%20document%20properties%20keep%20reverting%20when%20I%20save%20the%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2826913%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20experience%20a%20strange%20issue.%20Am%20on%20Sharepoint%20online%20and%20I%20have%20a%20Sharepoint%20library%20with%20several%20columns%20to%20that%20I%20update%20the%20document%20metadata%2Fproperties%20(manually%20or%20by%20a%20power%20automate%20flow).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%20from%20today%20for%20some%20reason%2C%20after%20I%20have%20updated%20the%20document%20metadata%2Fproperties%2C%20if%20i%20open%20the%20file%20and%20let%20it%20auto-save%20or%20even%20if%20I%20do%20change%20something%20in%20it%20and%20save%20it%2C%20all%20the%20recent%20metadata%2Fproperties%20gets%20wiped%20and%20those%20that%20remain%20get%20overwritten%20with%20the%20default%20values.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThrough%20investigating%20this%2C%20am%20pretty%20sure%20it%20isn't%20being%20caused%20by%20a%20rouge%20power%20automate%20flow%20as%20I%20turned%20them%20all%20off%20and%20it%20still%20did%20it.%20I%20think%20it%20has%20retained%20a%20value%20on%20the%20actual%20excel%20file%20property%20and%20this%20is%20what%20overwrites%20what's%20been%20updated%20on%20the%20column%20on%20the%20Sharepoint%20library.%20This%20happens%20immediately%20after%20saving.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20to%20resolve%20this%3F%20As%20I%20need%20the%20updated%20columns%20to%20remain%20as%20they%20are%20unless%20changed%20either%20manually%20or%20by%20a%20flow.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2826913%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2863255%22%20slang%3D%22en-US%22%3ERe%3A%20My%20excel%20document%20properties%20keep%20reverting%20when%20I%20save%20the%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2863255%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20following%20discussions%20with%20several%20tech%20help%20all%20the%20way%20to%20Microsoft%2C%20we%20have%20found%20how%20this%20is%20happening%20but%20still%20not%20sure%20why%20and%202%20work%20arounds%20for%20until%20Microsoft%20resolve%20what%20it%20is.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20we%20found%20that%20for%20some%20reason%20if%20you%20edit%20the%20properties%2Fmetadata%20then%20open%20the%20file%2C%20it%20seems%20to%20open%20the%20version%20which%20is%20sitting%20in%20your%20cache%20which%20is%20not%20necessarily%20the%20current%20version%20and%20therefore%20when%20you%20update%20things%20on%20it%20and%20save%2C%20it%20overrides%20the%20metadata%20to%20whatever%20is%20in%20the%20version%20you%20opened.%20With%20the%20Microsoft%20tech%2C%20we%20checked%20and%20could%20not%20find%20a%20reason%20why%20if%20you%20open%20a%20file%20directly%20to%20the%20app%2C%20it%20doesn't%20use%20the%20latest%20version%20of%20the%20file%20(although%20the%20content%20within%20it%20are%20up%20to%20date).%20This%20may%20be%20due%20to%20the%20change%20Microsoft%20is%20currently%20doing%20with%20removing%2Fretiring%20Upload%20Centre%20but%20we%20aren't%20sure.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20work%20arounds%20we%20found%20that%20worked%20were%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Open%20in%20browser%20mode%20only%20as%20this%20seems%20to%20retain%20the%20latest%20metadata%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20Open%20the%20file%20on%20the%20App%2C%20don%20save%2C%20simply%20close%20it%20again.%20Then%20re-open%20and%20this%20seems%20to%20then%20pull%20through%20the%20latest%20metadata%20too.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20still%20no%20fix%20but%20hopefully%20this%20saves%20someone%20some%20time.%20(If%20I%20made%20any%20sense%20at%20all).%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am experience a strange issue. Am on Sharepoint online and I have a Sharepoint library with several columns to that I update the document metadata/properties (manually or by a power automate flow).

 

However from today for some reason, after I have updated the document metadata/properties, if i open the file and let it auto-save or even if I do change something in it and save it, all the recent metadata/properties gets wiped and those that remain get overwritten with the default values.

 

Through investigating this, am pretty sure it isn't being caused by a rouge power automate flow as I turned them all off and it still did it. I think it has retained a value on the actual excel file property and this is what overwrites what's been updated on the column on the Sharepoint library. This happens immediately after saving.

 

Any help to resolve this? As I need the updated columns to remain as they are unless changed either manually or by a flow.

1 Reply

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