Corrupted DF/DSD dropdowns
Users complain that after some manipulations on the DSD/Dataflow/Matrix sheets (e.g., adding new rows between existing ones), the dropdowns become corrupted, unexpectedly changing the names on the DSDs/Dataflows sheet and duplicating them on the DSDs/Dataflows sheets without a possibility of changing them back as it changes names in several places.
Workaround: clean all problematic dropdowns on the Matrix sheet, modify incorrect DSD/Dataflow names, select the correct names from the dropdown on the Matrix sheet.
Problematic examples:
GOV_2023_-Generic_DSD_Matrix_SDMXML_generator-_corrupted_dropdowns.xlsm
REGIO_V1_main_OECD_DSD_Matrix_SDMXML_generator.xlsm