Skip to Content
0
Former Member
Jul 20, 2016 at 11:44 AM

Problem with data validation

25 Views

Hi,

I have an excel file, with a drop down list which is populated using data validation in excel. for some reason everytime i statrt my application this data validation is lost. is this a bug or is there something else i am missing?

basically this data validation is a country selector. once you select from the drop down your country, the currency is changed and certain default values are loaded for each country. this all works fine, but the drop down list dissapears when i load the file and i need to do the data validation in excel again. ot seems like this data validation is not kept or saved.

Any ideas?

Thanks

Harris

Attachments

Capture3.JPG (30.7 kB)
Capture2.JPG (16.5 kB)