xlsx files not updating sharepoint column values

%3CLINGO-SUB%20id%3D%22lingo-sub-1610451%22%20slang%3D%22en-US%22%3Exlsx%20files%20not%20updating%20sharepoint%20column%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1610451%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20change%20a%20value%20in%20a%20.xlsx%20property%20that%20has%20the%20identical%20name%20as%20a%20library%20column%20in%20sharepoint%20online%2C%20the%20column%20value%20doesn't%20change.If%20the%20file%20is%20.xls%20this%20problem%20doesn't%20exist.%20Anyone%20have%20any%20ideas%20how%20can%20it%20be%20fixed%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1610674%22%20slang%3D%22en-US%22%3ERe%3A%20xlsx%20files%20not%20updating%20sharepoint%20column%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1610674%22%20slang%3D%22en-US%22%3EAre%20you%20using%20the%20Export%20to%20excel%20feature%20in%20SPO%20lists%3F%20If%20so%2C%20the%20export%20feature%20works%20only%20one%20way%3A%20from%20SharePoint%20to%20Excel%20and%20no%20the%20other%20way%20around%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1610853%22%20slang%3D%22en-US%22%3ERe%3A%20xlsx%20files%20not%20updating%20sharepoint%20column%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1610853%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F770324%22%20target%3D%22_blank%22%3E%40AlexanderTzekov%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20to%20be%20clear%3A%20are%20you%20having%20problems%20with%20promoting%20properties%20from%20xlsx%20files%20like%20Title%2C%20Tags%2C%20Categories%2C%20...%20to%20SharePoint%20columns%3F%3CBR%20%2F%3EHow%20do%20you%20edit%20the%20xlsx%20file%3F%3CBR%20%2F%3EI%20just%20tested%20it%20on%20my%20tenant%20and%20when%20I%20edit%20the%20xlsx%20file%20using%20%22Open%20in%20app%22%20then%20changes%20to%20e.g.%20Title%20made%20within%20Excel%20are%20present%20in%20the%20SharePoint%20column%20after%20saving.%3C%2FP%3E%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1611739%22%20slang%3D%22en-US%22%3ERe%3A%20xlsx%20files%20not%20updating%20sharepoint%20column%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1611739%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20fully%20aggree%20with%20you%20this%20diagnosis.%26nbsp%3B%20I%20think%20the%20last%20version%20of%20SharePoint%20that%20allowed%20a%20list%20update%20from%20a%20linked%20list%20was%20SP2003!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1753816%22%20slang%3D%22en-US%22%3ERe%3A%20xlsx%20files%20not%20updating%20sharepoint%20column%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1753816%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F4831%22%20target%3D%22_blank%22%3E%40Paul%20de%20Jong%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%26nbsp%3BT%3CSPAN%3Eitle%2C%20Tags%2C%20Categories..%20work%20but%20the%20advanced%20properties%20don%60t%20and%20i%20edit%20it%20the%20same%20way%20in%20the%20desktop%20app.%20All%20of%20them%20have%20matching%20columns%20in%20SharePoint%20and%20xls%20files%20update%20them%20when%20changed%20in%20excel%20but%20xlsx%20don%60t%20do%20it.%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F224802i1F583F184E389F6C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F224803i1988E92E175ABFE9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

When I change a value in a .xlsx property that has the identical name as a library column in sharepoint online, the column value doesn't change.If the file is .xls this problem doesn't exist. Anyone have any ideas how can it be fixed?

4 Replies
Are you using the Export to excel feature in SPO lists? If so, the export feature works only one way: from SharePoint to Excel and no the other way around

@AlexanderTzekov 

Just to be clear: are you having problems with promoting properties from xlsx files like Title, Tags, Categories, ... to SharePoint columns?
How do you edit the xlsx file?
I just tested it on my tenant and when I edit the xlsx file using "Open in app" then changes to e.g. Title made within Excel are present in the SharePoint column after saving.

Paul

@Juan Carlos González Martín 

I fully aggree with you this diagnosis.  I think the last version of SharePoint that allowed a list update from a linked list was SP2003!

@Paul de Jong 
 Title, Tags, Categories.. work but the advanced properties don`t and i edit it the same way in the desktop app. All of them have matching columns in SharePoint and xls files update them when changed in excel but xlsx don`t do it.

 
 

image.pngimage.png