[SharePoint 2010] Export To SpreadSheet Button Disappeared (after migration to SharePoint 2010)

Question

Hi,

I realized a migration from SharePoint 2007 (MOSS 2007 Enterprise) to SharePoint Server 2010. (Strategy of migration : SPMountDatabases)

I kept both farm during a month to be able to compare behaviors.

Below my problem :

- On a specific list (a survey) on SharePoint 2010 version i don't have anymore "Export to SpreadSheet" button

- On my MOSS 2007 farm, on the same list, the button is there

I did a trick to create URL using http:// xxxxx / _vtin_bin_/owssvr.dll  so i could export correctly my list to Excel.

Does anyone knows how to put it back my button"Export to SpreadSheet" on my survey list ?

Thanks a lot

Etienne.

 

 

 

 

---

Etienne Bailly | SharePoint Consultant | My Blog

Answer 1

Bonjour Etienne,

Comme votre nom me semble "français", je vous parle en français.. :)

Consultez ce lien: http://weblogs.asp.net/wkriebel/archive/2005/08/22/LinkToExportToSpreadsheet.aspx

Et tu sûre d'avoir bien configuré le Excel Services et le Trusted File Location? Sinon check ce liens:

Trusted File location: http://www.gokanozcifci.be/subsite/creating-trusted-file-location.html

Excel Services: http://mssharepointtips.com/tip.asp?id=1041

 

Bonne chance, good luck, Gokan

---

Founder of SharePoint CookBook: http://www.GokanOzcifci.be
Microsoft Certified Technology Specialist: SharePoint 2010, Configuring
Microsoft Certified Personal

Answer 2

Thanks Gokhan for your answer (te$$ekürederim deme ?). But to my mind "Export to Spreadsheet" functionnality is not linked to Excel Services Features.

It should work all version of SharePoint (including "free" versions like WSS 3.0 or SharePoint Foundation)

It's very strange cause the "Export To SpreadSheet" button doesn't appear on some specific lists such this survey, but appears on others lists such as document libraries.

Etienne.

 

 

 

---

Etienne Bailly | SharePoint Consultant | My Blog

Answer 3

Bonjour,

   Je suis tombé sur ce thread : http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/ad663e6d-adbd-4770-ab5f-9d8cf6d2a9f0#524d170b-4983-4a98-ac4b-71d5c8f068fd

Apparemment le lien aurait été retiré de la vue par défaut, il faut passer sur la vue "Toutes les réponses" ou "Aperçu" pour retrouver le bouton.

Batiste.