Forum Discussion
SharePoint Choice Column In Excel Info Panel
Pretty sure I've come across a bug in the way SharePoint document library column data is exchanged with Excel documents stored in that library. When attempting to save SharePoint data through the Ex...
I'm also experiencing this with an existing .xlsx file in a SharePoint document library. The document properties can be updated through SharePoint's web UI and the workbook can be edited with no issues using Excel Online, but attempting to edit the workbook in the Excel desktop application gives the same error as the reporter. It is not possible to save changes made to the file in desktop Excel because Excel believes that mandatory document properties are not set, but it is not possible to edit the properties because of the script error described above. Document properties display OK in the Info screen, but they appear blank/unset in the Web File Properties dialog that generates the script error.
This makes it impossible to edit the workbook in Excel and so we have to use Excel Online for this workbook.
This makes it impossible to edit the workbook in Excel and so we have to use Excel Online for this workbook.
This seems to happen for all .xlsx workbooks in the document library. Attempting to view the document properties dialog in Excel generates the error even when the workbook is not checked out.
Excel version:
Microsoft® Excel® for Microsoft 365 MSO (Version 2109 Build 16.0.14430.20154) 32-bit
This is new behaviour since the last few months - it certainly was not an issue before July 2021.
Excel version:
Microsoft® Excel® for Microsoft 365 MSO (Version 2109 Build 16.0.14430.20154) 32-bit
This is new behaviour since the last few months - it certainly was not an issue before July 2021.
We are experiencing this same issue, found any solution to this?
