Subnm in large dimension
Posted: Tue Jan 07, 2014 2:50 pm
Dear all,
in an Excel-form, the user can select his costcenter via a subnm-formula:
=SUBNM(Server&"CostCenters";"SubsetName";"CC_Name";"ID_name")
The dimension is pretty large (~40.000 elements)
the subset-editor opens on doubleclick. when the user selects one of the elements of the subset and presses ok, the subset-editor closes within less than a second - all fine.
But:
If the user changes the subset (e.g. by expanding an element) and then leaves by "ok", it takes about 30 to 40 seconds to close the editor and the subset gets lost:
=SUBNM(Server&"CostCenters";"";"CC_Name";"ID_name")
(sure, as the user changed the subset)
how can I keep the performance when closing the subset-editor?
one possibility would be that the user saves his subset before selecting an element, but that will be hard to teach...
any idea?
regards
Mark
in an Excel-form, the user can select his costcenter via a subnm-formula:
=SUBNM(Server&"CostCenters";"SubsetName";"CC_Name";"ID_name")
The dimension is pretty large (~40.000 elements)
the subset-editor opens on doubleclick. when the user selects one of the elements of the subset and presses ok, the subset-editor closes within less than a second - all fine.
But:
If the user changes the subset (e.g. by expanding an element) and then leaves by "ok", it takes about 30 to 40 seconds to close the editor and the subset gets lost:
=SUBNM(Server&"CostCenters";"";"CC_Name";"ID_name")
(sure, as the user changed the subset)
how can I keep the performance when closing the subset-editor?
one possibility would be that the user saves his subset before selecting an element, but that will be hard to teach...
any idea?
regards
Mark