I have found that when doing DV on one sheet and the range of data is on another sheet, it always works better to assign a range name to the data and then in the DV set up, you can then choose the range, ie. =MyRange.