This tool give you the option to replace all your dropdowns with the latest values from the Database or reapply the format of the cells. You can use this options if you have some QRT being corrupted. You can apply this functionality on a cell, sheet or whole workbook level. Note that the replace Validation option will add any dropdowns that are not existent at the moment in the workbook but they are in the database.
Post your comment on this topic.