Try "Save As"

>I'm importing a few hundred megabytes of data from various excel sheets, just like I always did, nothing new.
>
>Or so I thought.
>
>It's the dates. The sheets are the 97/2003 format, which open fine in my excel 2003. However, the client has excel 2010 installed, and that's where the trouble began. The date fields' cell.value would return an OLE error if there was the long negative value which represents a null date, instead of returning a null like it did in 2003.
>
>So I had to check the cell.text... which would be "####" of some length in such cases.
>
>Except it's not. It's hashes whenever Excel 2010 can't display the date in full length - and if it's a 97/2003 file, it doesn't even try to widen the column. So I had to open each file, widen the date columns, save... and then it wouldn't save in xls format, it insists on xlsx (maybe there's an option to allow saving in xls, but it's hidden somewhere, and it would already be about tenth option on top of those I had to search for before it would even open these files).
>
>It wasn't broken, but thanks my good luck, they fixed it. Or at least tried to.