Required choice column reverts to previous choice in library

kmktnn The root cause you've identified, which is related to the way Excel handles the caching of document properties, is an insightful finding. It's often these seemingly innocuous client-side factors that can have a significant impact on the user experience, and your persistence in uncovering the underlying issue is commendable.

The recommendation to clear the cached files in the Excel options is a pragmatic solution that should address the problem for end-users. However, I would encourage you to explore potential long-term strategies to mitigate this issue, such as educating users on the importance of regularly clearing their cached files or investigating any Excel or SharePoint configuration settings that could help prevent the caching behavior from causing problems.

Additionally, it might be worth considering whether there are any SharePoint-specific solutions, such as custom scripts or web parts, that could help streamline the update process for these required choice columns and ensure a more seamless user experience. While the client-side caching issue is the primary driver of the problem, there may be opportunities to enhance the overall functionality and reliability of the solution. I'm grateful for your diligence in troubleshooting and documenting this issue, as it not only helps resolve the immediate problem for your organization but also contributes valuable insights that can benefit the broader SharePoint community.

Please feel free to reach out if you have any other questions or if there's any way I can assist you in further refining your SharePoint environment and addressing similar challenges that may arise in the future.