I thought I knew how to do this but I seem to be regressing. I would appreciate being told again.
I drive various calculations and displays from scenarios that are selected ib a list or combo box. Works fine. But because I have several pages in the dashboard, I need to give the user the ability to select scenarios on each page. So I have the same combo box on each page.
Individually, each selector works as planned. But if I select the scenario on one page and then go to the next page, although the next page displays and calcs are indeed driven by the selected scenario, the label displayed in the combo box hasn't changed, which is quite confusing for users. What I want to do is to link the combo boxes in such a way that when a selection is made and shown on one, all of them show that selection.
All the combos point to the same destination cell and I have uncecked clear destination (and tried multiple combinations too) but it's not working.
Please let me know if you have any suggestions.