Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error Alert for Invalid Data doesn't work for data selected in col
Good afternoon everyone,
Just as a basic introduction, My name is Gene, and I'm working at a company producing a CRM database, which includes an Excel template file that I provide the employees to fill in so that they may fill in the contact details while away from the database and add them whenever possible. I have my database currently linked to an Access database, so that on start-up of the Excel file (I've saved both an XLSX and XLS format for testing purposes) the excel spreadsheet will update any details (if changed) for lists such as countries, employees and services (list of divisions of the company). I have no problem creating the data link between the two, and the the 'connections' settings and 'properties' are all set to how I would like them to work. The imported data for the countries, employees and services are all saved in their own individual worksheet. Now, the idea is to have a drop-down list (from Data Validation) to list the countries, employees and services as stored in the independent worksheets. What I experienced with Excel is that Excel can't use a data range which might change in size; it prefers to refer to a fixed range (a fixed number of cells, a single column/row). So I had to select the column where the data sits. I named each column with titles such as "Country", "Service" and "Employee". I used the Data Validation tool to locate each range, and the list works perfectly. However, when I intended to use error checking for invalid data, it doesn't work. If I enter in the wrong information, it passes the error checking and doesn't register as invalid data. Now I have a problem of trying to solve this problem. Has anyone else experienced this? What is the solution? Thanks for your help everyone, Gene. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error "invalid data source reference" for pivot table | Excel Worksheet Functions | |||
data validation error alert does not work | Excel Discussion (Misc queries) | |||
GETTING SELECTED DATA FROM A WORK SHEET TO OTHER WORK SHEET | Excel Discussion (Misc queries) | |||
Data Validation: Printing Invalid Data Circles | Excel Discussion (Misc queries) | |||
Data Validation Error Does Not Work? | Excel Worksheet Functions |