Update Template tool did not go well

[DougBrowning]

Some of my forms are 3+ years old.  I tried the new update template tool today and well it did not go great.

All my drop downs are a mess now.  Errors on everything

Any ideas here?  thanks

[ZacharySutherby]

Hello @DougBrowning, 

What version of openpyxl is being used in the Python environment you have configured with Connect? 

[DougBrowning]

Thanks.  For now I went old school and did it column by column.

[ZacharySutherby · Accepted solution]

Hello @DougBrowning, 

Thank you for confirming! There was an openpyxl bug at that version (and prior) that is causing the data validation issue you are seeing. If you update ArcGIS Pro to the latest 3.0.3 version that should update your openpyxl package to 3.0.9 and the issue should be resolved. Alternatively you can clone your default Pro Python environment and update the package directly in the cloned environment. 

[DougBrowning]

I can't move to ArcPro 3 yet but thanks for the answer.