Thursday 19 June 2008

not able to export list data to Spreadsheet "Cannot get the list schema property from the SharePoint list."

"Cannot get the list schema property from the SharePoint list."

This issue will not occur if the user has MS Office 2007, but for any user who does not have MS Office 2007 here is the solution.

1. Modify the Date/Time field to Single Line of Text

2. Then Modify it again to Date/Time field

This has to be done for all the date and time fields except for the default date and time fields(Created, Modified etc)

21 comments:

MarkF said...

Thanks for the tip !

Marty O'Brien said...

That is messed up! But it works!!!!

P.S. You are the only, single result on Google when I searched for that error message. Congrats! You're famous! :-)

Bouv in Virginia said...

DUDE! Awesome.

steve said...

well done posting this, thanks

barbara said...

Thanks very much. One thing though, you have to change each date field, ONE AT A TIME. It did not work when I changed all my date fields to single line of text and then back again. One at a time... slow... but at least it worked! thanks, this was a lifesaver

Anonymous said...

Pretty interesting place you've got here. Thank you for it. I like such themes and everything that is connected to them. I definitely want to read a bit more on that blog soon.

Hilary Swenson

Anonymous said...

It was extremely interesting for me to read this post. Thanks for it. I like such themes and anything that is connected to this matter. I definitely want to read more soon.

Avril Hakkinen

Anonymous said...

Pretty nice blog you've got here. Thanx for it. I like such topics and everything that is connected to them. I definitely want to read more soon.

Avril Kuree
escort girl swiss

Anonymous said...

Rather nice site you've got here. Thank you for it. I like such topics and anything connected to this matter. I would like to read more on that blog soon.

Anete Smith
elite escorts

Anonymous said...

Rather interesting place you've got here. Thanks for it. I like such themes and anything connected to this matter. I definitely want to read more on that blog soon.

Julia Smith
escorte girls kiev

Anonymous said...

Great story you got here. I'd like to read a bit more about this theme. The only thing I would like to see on that blog is a few pictures of any gadgets.

Alex Trider
phone zappers

Anonymous said...

Pretty nice blog you've got here. Thanks for it. I like such themes and anything that is connected to them. I would like to read a bit more on that blog soon.

Julia Simpson
independent escort limerick

Anonymous said...

Between us speaking.

Anonymous said...

Grourseindine
[url=http://healthplusrx.com/cortislim-reviews]cortislim reviews[/url]
ToogTymnUnill

Anonymous said...

It is certainly interesting for me to read that article. Thanks the author for it. I like such topics and everything that is connected to them. I would like to read a bit more on that blog soon.

Bella Swenson
ebony escorts in uk

Anonymous said...

Damn, rather nice topic. Where will I get that RSS?

Nicky Meetington
spy source

Anonymous said...

Impressive text. Waiting for you to continue the topic.

Hilary Swenson
independent escort warsaw

Anonymous said...

I am really Glad i ran across this site.Added hemanthsali.blogspot.com to my bookmark!

Anonymous said...

It's cool. I like your blog. Well done!

Kelly Spring
agencesescortgirlgeneve

Anonymous said...

Pretty nice place you've got here. Thanks the author for it. I like such topics and anything connected to them. I definitely want to read more on that blog soon.

Kate Benedict
ny independent escort

Anonymous said...

1