I’ve had this problem too. I think it was because the SharePoint site was created with MOSS 2007 beta. Try opening that xls file with Excel 2007 and it should work OK.

Adam

One other work around is create a duplicate column for those date/time columns and copy all the data over. That worked for me as well.

Changing the date and time feilds into a single line and then back to a data and time field fixed the problem. Thanks for the input.

Creating another column and copy/pasting the values worked here as well, thanks. I read somewhere that changing the column names might cause this problem also, but can’t test now since I deleted the old columns.

Thanks for the info Rob.

Thanks for this workaround! It is very helpful to have this resourse here.