Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data validation in Excel 2007
Hi,
Not sure what you mean, by default Excel handles the structure references and they automatically expand and contract as the structure of the table changes. You can still use old fashioned dynamic range names. -- Thanks, Shane Devenshire "Aeronav" wrote: Hey, In Excel 2002 I could create a dynamic name =DECALER(Feuil1!$A$1;;;NBVAL($A:$A)-1;1) to cover a list of data used for setting validation rules. In Excel 2007 I tried to use the new "structured references" for the same purpose, but Excel refuses, saying that there is an error in my formula. For example : =Tableau1[ [#donnes] ; [Produit] ] which works well for formulas in cells ( french version needs a semi-colon for separator) is not accepted in the validation dialog box. Is it impossible ? and I will stay with dynamic names, or is there a way to turn around this ? Thanks Bern. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why the data validation button is greyed out when it is in trackchange mode in Excel 2007 | Excel Discussion (Misc queries) | |||
Why the data validation button is greyed out when it is in trackchange mode in Excel 2007 | Excel Discussion (Misc queries) | |||
data validation in Execl 2007 | New Users to Excel | |||
Data validation Excel 2007 | Excel Worksheet Functions | |||
Excel 2007 and Drop Down List via Data Validation | Excel Discussion (Misc queries) |