• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data validation with combo box

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)
 
Hi, roypabitra!


Perhaps you'd want to read the green sticky posts at this forums main page so as to know the guidelines that will lead to know how this community operates (introducing yourself, posting files, netiquette rules, and so on).


If you'd have read the main green sticky post at this forums main page...

http://chandoo.org/forums/topic/phd-forum-posting-rules-etiquette-pls-read-before-posting

...you should have noticed the 10th. point:

"PLEASE DON'T SHOUT! We have big ears and will hear you just the same."


Regards!


PS: I'd suggest you to edit your post clicking on the "EDIT" link below it and adjust text to proper case. Same for the title.
 
Hi, roypabitra!


There's a known issue regarding data validation between versions 2007 and 2010. This is the link to a Microsoft page where it's treated, would it help?

http://answers.microsoft.com/en-us/office/forum/office_2010-excel/excel-2010-2007-data-validation-compatibility/20a6e301-f5b7-459a-9ee4-867496342119


Regards!
 
Respected Sir,


Sir, But I work in only excel-2007 I never work in Excel-2010 but I save the file as .xls format. So, Sir, It is possible to keep the data validation after saving the file.


Thanks & Regards


Pabitra Roy
 
Hi, roypabitra!

I'm afraid it isn't possible, check this:

http://answers.microsoft.com/en-us/office/forum/office_2010-excel/excel-2010-data-validation-warning-compatibility/d4dc903f-e9f8-4d4c-93bd-12c5730d74eb

Regards!
 
Back
Top