Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Error Checking doesn't work on column ranges?
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Error Checking doesn't work on column ranges?
Problem solved.
I had to disable "Ignore Blanks", and that somehow disabled invalid data from being added |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I remove multiple 'errors' in Excel error checking, at the same time??? | Excel Discussion (Misc queries) | |||
Checking Column Status on closing excel - Macro Needed | Excel Discussion (Misc queries) | |||
Are Error-Checking rules (in Excel Options) workbook-specific? | Excel Discussion (Misc queries) | |||
Error Checking | Excel Discussion (Misc queries) | |||
Basic Error Checking in Excel VB | Excel Discussion (Misc queries) |