Exporting to Excel - value list problems.
I have a table layout created using tab controls. These are two fields in it:
1) Race: field formatted as drop down list including a value list of white, hispanic, latino etc
2) family history: field formatted as dropdown list including values of mother father, sibling
When I make a new layout ie a basic list view and when i export to excel, these fields display "0" and not white, hispanic or mother, father as in my layout. Why is this happening? Please help!