Thanks for you help Scott. I'm not quite there yet. When I open the new saved file, it says "Excel found unreadable content in file. Do you want to recover the contents of this workbook? If you trust the source of this workbook click yes". I clicked Yes and a repair message said "Removed Feature: Data validation from /xl/worksheets/sheet1.xml part".

I glad it removed the data validation, but is there a way to avoid the error messages?