I have a sheet which uses data validation to enter values into my sheet.
My problem is that if I type the data validation list as numeric values in the source box, all my formulas work OK. However if I use values from a range of cells (which is the way I need to do it for the sheet operate as required) then the values are not recognised by the sheet unless once the data is entered, I then re-highlight the cell and hit ENTER.
This is not acceptable behaviour and I need to figure out how to overcome this limitation. I'm using Excel 97 if that makes any difference.
Thanks in anticipation of a working outcome.
My problem is that if I type the data validation list as numeric values in the source box, all my formulas work OK. However if I use values from a range of cells (which is the way I need to do it for the sheet operate as required) then the values are not recognised by the sheet unless once the data is entered, I then re-highlight the cell and hit ENTER.
This is not acceptable behaviour and I need to figure out how to overcome this limitation. I'm using Excel 97 if that makes any difference.
Thanks in anticipation of a working outcome.