Forum Discussion
AlexanderTzekov
Aug 25, 2020Copper Contributor
xlsx files not updating sharepoint column values
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 ...
Paul de Jong
Aug 25, 2020Iron Contributor
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
- AlexanderTzekovOct 07, 2020Copper Contributor
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.