Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a form in excel so I can enter data using DataForm
I am trying to create a database in Excel with headers so that I can enter
new data using the Form feature. I am running Excel 2003. I can create the named range but when I click anywhere in the range and then select DataForm, I get an error message that says "Database or list range is not valid." I am not sure what I am doing wrong. Lynn |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a form in excel so I can enter data using DataForm
Maybe...
http://support.microsoft.com/default...;en-us;Q110462 ShowDataForm Method Fails If Data Can't Be Found Lynn wrote: I am trying to create a database in Excel with headers so that I can enter new data using the Form feature. I am running Excel 2003. I can create the named range but when I click anywhere in the range and then select DataForm, I get an error message that says "Database or list range is not valid." I am not sure what I am doing wrong. Lynn -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a form in excel so I can enter data using DataForm
Dave, this was helpful. I renamed by named range database and the form
worked. Thanks! Lynn "Dave Peterson" wrote: Maybe... http://support.microsoft.com/default...;en-us;Q110462 ShowDataForm Method Fails If Data Can't Be Found Lynn wrote: I am trying to create a database in Excel with headers so that I can enter new data using the Form feature. I am running Excel 2003. I can create the named range but when I click anywhere in the range and then select DataForm, I get an error message that says "Database or list range is not valid." I am not sure what I am doing wrong. Lynn -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a form to enter data | New Users to Excel | |||
i enter a lot of data in xl. cani create a form | Excel Discussion (Misc queries) | |||
Create form to add data to Excel 40 odd columns | Excel Discussion (Misc queries) | |||
Can I use a FORM to enter data if I have more than the 32 fields? | Excel Discussion (Misc queries) | |||
how do i create a data collection form in excel? | New Users to Excel |