I'm new using Analysis for Office. Currently we are using the latest version 2.5 to create some manual data.
We have some problem when user input the wrong value in the selection screen. The location should be SG, but user didn't use the help F4 and directly type SINGAPORE instead of SG. Actually after user execute the selection screen, there is warning said that SINGAPORE doesn't exist in the master data, user ignored it and save the data. Now we have SG and SINGAPORE.
My question is there anyway to prevent user, so they only input the value based on master data that we have?