| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DataVaildationList works in Sheet1, but does not in Sheet2; Why
I do not get the drop down list in sheet2; I get it in Sheet1 and it works
correctly; Sheet 2 is a large Excel file (1500 rows). could it be related to size of sheet? is there a configuration parameter to remedy this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DataVaildationList works in Sheet1, but does not in Sheet2; Why
Is the Sheet2 DV trying to use a list in Sheet1? If so, you need to use a
Defined name and use that name in the DV. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "rseeley" wrote in message ... I do not get the drop down list in sheet2; I get it in Sheet1 and it works correctly; Sheet 2 is a large Excel file (1500 rows). could it be related to size of sheet? is there a configuration parameter to remedy this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List a group of repeated data from sheet1 to sheet2 but not repeat | New Users to Excel | |||
| copying data from sheet1 to sheet2 | Excel Worksheet Functions | |||
| How To Retrieve Data from Sheet2 into Sheet1 | Excel Worksheet Functions | |||
| How do I list all sums from sheet1 to sheet2? | Excel Worksheet Functions | |||
| Looking for comparable data records between Sheet1 and Sheet2 | Excel Discussion (Misc queries) | |||
Hybrid Mode
