Unable to convert data to a table

[allenwgulley]

I have a spreadsheet that I use every day to format a set of data. I open the spreadsheet, import a CSV file, then apply some formatting before distributing a very simple report. Once in a while I will make a mistake and have to delete the contents of the sheet and start over again. The problem is that when I start over and re-import the data I am unable to convert it to a table. I select the entire range and select Format as Table. The little box that confirms the location of the data appears but when I click OK nothing happens. The only way I have found to remedy this is by deleting the entire worksheet and creating a new one. Anyone have any ideas what I might be doing wrong? My theory is that when I originally import the data and convert it to a table that something in the underlying formatting of the worksheet changes that will not allow the same data to be imported and converted. Any help is appreciated.