roypabitra
Member
Respected sir,
I have data sheet I a.xls file where I store different ledger name. Now I create a cash.xls file where I creat data validation with combo box , when I double click in data validated cell I select data by typing from a.xls file. After that I save the all file and close excel. But as when I reopen the all files then I found that all data validation in cash.xls file is missing and again I formatted the data validation format but after reopen same happened. Please help me how to solve it ?
EDIT: LCase (SirJB7)
I have data sheet I a.xls file where I store different ledger name. Now I create a cash.xls file where I creat data validation with combo box , when I double click in data validated cell I select data by typing from a.xls file. After that I save the all file and close excel. But as when I reopen the all files then I found that all data validation in cash.xls file is missing and again I formatted the data validation format but after reopen same happened. Please help me how to solve it ?
EDIT: LCase (SirJB7)