0

I know it is possible to define on an excel file some custom properties. And this properties can take the value from a determined excel cell.

With this properties created, in a document library you can create columns with the same name as the custom properties. Then when uploading this excel file to SharePoint, this SharePoint columns automatically get the value defined in the custom properties.

So at the end, the SharePoint column gets the value reflected on the excel cell at the moment the document was uploaded.

https://support.microsoft.com/en-us/office/use-cell-values-as-a-custom-excel-file-property-to-help-manage-your-workbooks-in-a-sharepoint-library-e0f0658a-76dd-4c6a-97d4-8e20e3744ec2

What I don't know, is if this behavior can be configured somehow bidirectional, this means, after uploading the excel file to SharePoint, if I edit the value of the SharePoint columns, the change gets reflected in the excel cell or on the custom property.

There is anyway to achieve this?

0

It will not be updated automatically, you could check this UserVoice: Support custom property in Excel for the web

1
  • Thank you! Do you know any valid alternative to modify then the cell value from content set in the library columns? Aug 26 at 10:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.