Quick way to update POV when multiple forms downloaded from FCCS into SmartView
Users are frustrated that having created a suite of forms in SmartView to load data to FCCS, they have to update the variable POV members on each sheet individually and cannot link them to a single front page where they can update everything at once.
FCCS forms have been built with user variables for entity, period and years and once opened in SmartView these are presented in the POV ribbon above the form. Users have maybe 30 forms in a single workbook and want to be able to change the entity code when they start working on a different entity. Is there are way to make the variable dimensions more dynamic or to link them to a single source?