I am using Microsoft Office Professional 2013 with Excel 2013 on a Window 7 Enterprise Laptop.
I have run into a problem that I cannot correct. I have a worksheet that I have been tracking data in since January 14. One of my column values is a data validation list which points to a tab labeled controls. All of a sudden when I click on the cell in the row the drop down control does no work. If I try to type a value not defined where the list is located I get an error message telling me I am attempting to add a value not in the list. I gather the data and enter it into the workbook on the appropriate months tab. Once the weeks data is compiled I save it as new document adding v1, v2, v3 etc. depending what week of the month. Version 4 works, but the new Version 5 does not. Does anyone have any idea why this maybe happening?