Dropdown to assist user to rebind a pivot table’s dimension when underlying source column label has changed
Do you plan to have a good way to assist the user to interactively repair a pivot table’s orphaned labels following an incompatible repasting of it’s source table? For example, a source table’s column is renamed and I don’t want the pivot table to just drop the corresponding dimension without giving me the opportunity to rebind it to the new source column. Unfortunately, most often, right before I do a refresh on the pivot table I am most likely to forget to look for what might go missing from it. Cheers, Henk.