Finding and Removing Data Validation

However, each time I uploaded the file I got an error that the spreadsheet contained data validation. After some research, I found a way to locate cells that used data validation within the workbook. Using a special search feature in Excel 2007, Home -> Find & Select -> Data Validation, I was able to locate the cells that used data validation. I could then use Data -> Data Validation… -> Clear All to remove it from that cell. Once all the data validation had been removed I was able to upload the file using excel services and display it in my portal.