I work on a help desk and a user sent me an excel worksheet that has a column for dating. It will not allow me to enter a date earlier than 1/1/99. I have tried to switch the dating formats around, taken all security off of the sheet, and even copied and pasted all info into a new workbook. I am at a loss. The error tells me: The value you entered is not valid. A user has restricted values that can be entered into this cell.
Anyone got a clue???
Anyone got a clue???