Openpyxl loses data validations referencing lists of cells for drop-downs when loading an existing workbook
So I'm working with an existing workbook and populating some data for it. The workbook is available publicly here. It can also be accessed by clicking the 2021 Real Estate Asset Spreadsheet (Excel format)
button on this page. In case the file is taken down (as it is a yearly spreadsheet) I've uploaded a copy to my personal OneDrive here.
When loading the workbook, I check the data validations on the sheets, and any sheets which contain data validations referencing other cells seem to have disappeared.
They reference a hidden sheet 'Lists', but even when I unhide the sheet and save the workbook, openpyxl doesn't seem to find them.
As a temporary workaround I'm going to manually recreate the references so they are not lost when saving the populated workbook, but a fix for this would be very useful!
There seems to be someone with similar issues here: https://stackoverflow.com/questions/44337946/openpyxl-causing-loss-of-existing-datavalidation-in-excel