Applies to Product – Microsoft Dataverse
What’s happening?
The description column for the task entity is formatted as rich text, which is preventing users from editing exported Excel files in Excel Online. Users encounter an error message stating "Workbook repaired" and are unable to edit any values.
Reason:
This arises because the rich text formatting in the description column includes HTML tags, which are not compatible with Excel Online. When exported, these tags can lead to file corruption or errors during the editing process.
Resolution:
- Need to remove the description column from the view before exporting to Excel. This can be done by using the UCI column editor to exclude the column.
- If the issue persists after removing the description column, advise the user to progressively reduce the number of records in the export until the problematic entry is identified.
- Need to check for any special characters or formatting in the description field that may be causing the issue.