I want to give the users the possibility to work in their local language.
My template works fine for this, except for 1 thing:
There is a cell that is data validated. Once a user has made a choice in his local language and the file is saved to a sharepoint, somebody opening the file and viewing it in another language, will never see the validated cell content in his selected language.
Did somebody tried and succeeded this before?
I was thinking on just saving a number and then lookup the value as i do for the other fields, but still at the moment of selection, it should show the different options, not just the number