Board index sharepoint

Export survey results to a spreadsheet fails

Export survey results to a spreadsheet fails

Post by TWFudHZ5ZG » Sat, 01 Apr 2006 01:50:02


Hello, there,

I have a quite a long survey done on the sharepoint services. It was quite
successful, I had 400 answers from our company employees.

However, I was so badly surprised, that a button "Export survey results to a
spreadsheet" produced me nothing in Excel.

1. I pressed the "Export..." button in WSS.
2. It warned me: To export a list, you must have a Windows Sharepoint
services-compatible application. I pressed Ok to that.
3. Then Excel activated with a "Opening Query" dialog box. It mainly said
bla bla: "There's owssvr.iqy... it has external data... able to perform
harfmul actions... If you trust click Open". So I press Open.
4. The Excel 2003 SP2 promptly opens, shows for a second an empty sheet,
lower left corner promptly shows Connecting to datasource... AND... a sheet
closes, leaving an Excel app open with nothing inside, not even an empty
sheet.

I thought maybe I just can't connect to a datasource, but the following .iqy
sentence strangely succeeds:
http://wssserver/_vti_bin/owssvr.dll?Cmd=Display&List={96F61E90-42D2-4C74-B717-DF3F0246453A}&XMLDATA=TRUE I do get a *** XML file with data inside.

The original failing .iqy query is this
http://wssserver/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={96F61E90-42D2-4C74-B717-DF3F0246453A}&View={63389BB9-DBE7-4FA4-A7EB-BBFB60DF986A}&CacheControl=1
 
 
 
Top

1. How do I create survey results into an Excel spreadsheet?

2. What's a non-coder to do exporting survey results from Out

Dier Sue Mosher,
Is there any possibility to export/import custom view?
Thank you in advance,
XXXX@XXXXX.COM

"Sue Mosher [MVP-Outlook]" :

3. trouble exporting all survey results

4. What's a non-coder to do exporting survey results from Outlook

5. Exporting survey results

6. cannot export survey results to execel via interface.

7. Export SharePoint Survey Results with Rating Scale questions to Excel

8. Using "At Your Survey" for storing and comparing survey results of each year

9. Surveys in SPS - Where are survey results collected and how do I get at them

10. Using "At Your Survey" for storing and comparing survey results of

11. how to export result to excel spreadsheet???

12. hlp needed on how to export result to Excel Spreadsheet

13. Exporting results to spreadsheet

14. Exporting query results to a spreadsheet

15. Unexpected results when exporting to spreadsheet

All times are UTC
Board index