Is data validation incompatible between excel 2007 and excel 2010?

In machine A, I added data validation khổng lồ some cells of a sheet using Excel 2010. The menu of data validation values is in another tab in the same file. Then I moved the workbook to a shared folder. In machine B, I opened this in Excel 2007 and found the data validation had gone.

Bạn đang xem: Is data validation incompatible between excel 2007 and excel 2010?

How can I debug/troubleshoot this issue?

Data validation (and conditional formatting) references can point khổng lồ a different sheet in Excel 2010 & later. In versions earlier than 2010, though, this will not work.

You will need to create a named range for the cells that feed the data validation. So, in the sheet with the menu of values, select the values & click the Formulas ribbon > Name Manager > New > enter a name for the range (or use your favourite technique khổng lồ create a named range). Then mix the data validation khổng lồ the menu option and let it refer to the range name, like

=MyRange

(where "MyRange" is the name of the range you just created) This will work in all current versions of Excel.

Data validation (and conditional formatting) references can point lớn a different sheet in Excel 2010 và later. In versions earlier than 2010, though, this will not work.

Xem thêm: Tuyển Tập 13 Bộ Phim Tình Yêu Tuổi Học Trò Thái Lan Hay Nhất Mọi Thời Đại

This is not true. In 2007 you can reference a range from another sheet by typing it in (it won"t let you select the cells from the other sheet). E.g =Dropdowns!$D$3:$D$84

Not that this matters really for this problem which seems fairly bizarre!Also thanks for the answer which did solve this issue which I was having.

Thanks

Thanks for contributing an answer lớn Super User!

Please be sure to answer the question. Provide details và share your research!

But avoid …

Asking for help, clarification, or responding to other answers.Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Post Your Answer Discard

By clicking “Post Your Answer”, you agree lớn our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged microsoft-excel or ask your own question.

Site kiến thiết / logo © 2022 Stack Exchange Inc; user contributions licensed under cc by-sa. Rev2022.6.21.42420

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.