If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
DataValidation Question
Hello and greetings from South Texas (very cold). I've created a simple
spreadsheet report with six different categories (columns). In two of those categories I implemented drop down lists using DataValidationList, etc. Initially it worked like it was supposed to therefore giving me the luxury of selecting different options from the drop down menu. I locked several cells (not including the two columns) and protected the worksheet with a password. As I opened the file this morning I deleted the current information in an attempt to enter new information (expecting the drop down fields to be in tact), but the drop down list has dissappeared. The list of information is still located on page two, but the drop down is no longer there. I've tried restarting, protecting/unprotecting, redoing the validation list, etc., but to no avail. Sorry for the narrative. Can you help please? John |
#2
|
|||
|
|||
DataValidation Question
The only thing I can think of is that when you deleted, you deleted rows or
cells. This would take out the drop down. Just being in the cell where the drop down is and pressing delete won't take out the drop down. "Weave" wrote: Hello and greetings from South Texas (very cold). I've created a simple spreadsheet report with six different categories (columns). In two of those categories I implemented drop down lists using DataValidationList, etc. Initially it worked like it was supposed to therefore giving me the luxury of selecting different options from the drop down menu. I locked several cells (not including the two columns) and protected the worksheet with a password. As I opened the file this morning I deleted the current information in an attempt to enter new information (expecting the drop down fields to be in tact), but the drop down list has dissappeared. The list of information is still located on page two, but the drop down is no longer there. I've tried restarting, protecting/unprotecting, redoing the validation list, etc., but to no avail. Sorry for the narrative. Can you help please? John |
#3
|
|||
|
|||
DataValidation Question
Well, I've copied the old form into a new workbook and installed the drop
downs again. It seems to be working fine. We'll see. Thanks JR. "JR" wrote: The only thing I can think of is that when you deleted, you deleted rows or cells. This would take out the drop down. Just being in the cell where the drop down is and pressing delete won't take out the drop down. "Weave" wrote: Hello and greetings from South Texas (very cold). I've created a simple spreadsheet report with six different categories (columns). In two of those categories I implemented drop down lists using DataValidationList, etc. Initially it worked like it was supposed to therefore giving me the luxury of selecting different options from the drop down menu. I locked several cells (not including the two columns) and protected the worksheet with a password. As I opened the file this morning I deleted the current information in an attempt to enter new information (expecting the drop down fields to be in tact), but the drop down list has dissappeared. The list of information is still located on page two, but the drop down is no longer there. I've tried restarting, protecting/unprotecting, redoing the validation list, etc., but to no avail. Sorry for the narrative. Can you help please? John |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Question about reducing number of tables in a database | tlyczko | Database Design | 0 | October 27th, 2005 04:15 PM |
x-post from previous question | justin | Using Forms | 2 | April 13th, 2005 09:48 PM |
A report design question | Al | Setting Up & Running Reports | 3 | March 11th, 2005 09:41 PM |
How to create a query with multiple answers to a question? | Amit | Running & Setting Up Queries | 4 | November 9th, 2004 04:52 PM |
database design question | e-mid | Database Design | 9 | June 16th, 2004 09:42 PM |