The following are comments that didn't get migrated properly....

1.
adam said,

October 27, 2007 @ 10:40 am · Edit

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
2.
adam said,

October 27, 2007 @ 10:41 am · Edit

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.
3.
admin said,

October 27, 2007 @ 10:45 am · Edit

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.
4.
Rob said,

November 6, 2007 @ 9:23 am · Edit

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.
5.
admin said,

November 6, 2007 @ 10:44 am · Edit

Thanks for the info Rob.
6.
Dan Morgan said,

November 19, 2007 @ 4:49 pm · Edit

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

Great solution if you're not using the time field--if your column is date AND time DO NOT USE this solution becuase you will loose the time data when you try and revert back.

im having the same problem here. Does changing the date field to a single line of text and then revert back the type loses the data? Do i have to do this change everytime i need to export to a spreadsheet?

Thanks you all, i did created the view ( and removed the date column all together and then exported sheet , this
way it wont change the default view

Help. I changed all DATE fields to single line text fields...still get same pop-up error message.

I have two computers - desktop and laptop --

all of the sudden today, on my desktop, I click on export to spreadsheet and absolutely nothing happens.

No error message, no nothing.

It worked yesterday and it is will working today on my laptop.

Why is that???

even if it worked yesterday? nothing on my computer settings changed. I use this same function a couple of times a week.