It is not allow for the excel to create a list in other tabsheet. Try to have the database at the last coloum.
1. Go to Data
2. Validation
3. Settings
4. Allow: choose List
5. Source: Database area.
2007-04-02 15:01:01 補充:
oh! I found out that you need first defind the list, and then in the validation type =Define NameFor example, you defind the list call listAThen in the validation type =listA
2007-04-02 15:03:23 補充:
For Define the Cell Highlight the rangeChoose insertNameDefineType the list NAME that you likeclick oK