Thank you! I didn't need the cell link box but you got me looking in the right place to fix it!
I made the cell in question by using the Data tab - Data Validation - Settings - List - In Cell drop down and then typing in the source box the information seperated by commas. So that is why I thought it was a Data Validation list.
I right clicked on the data list cell went to format cells and under the protection tab it had the box for locked checked. I undid the lock and it works perfectly now.
Bookmarks