Problems with importing a spreadsheet to a SharePoint list
Hello allThis might be an easy question to answer for you guys.I have got a *.xlsx file which I'd like to import to a SharePoint list over the Import spreadsheet funktion.Unfortunately during the process of import the errormessage "The specified file is not a valid spreadsheet or contains no data to import" appears.I don't know what the problem is, the excelfile looks good.Can you help me with this?GreetingsJussi
May 7th, 2009 5:27pm
Hi Jussi,To exclude the possibility that the spreadsheet itself had problems, please try the following steps to import spreadsheet:
1. Create a new OOB list, for example: announcement list.
2. Export the list to a spreadsheet.
3. Create a list from the exported spreadsheet.
If you can import spreadsheet without problems, the cause of the issue should be the *.xlsx file itself.
If you cannot find the root cause in the *.xlsx file and there is no sensitive data in the file, please upload it to the workspace to me for further research:
Workspace URL: (https://sftus.one.microsoft.com/ChooseTransfer.aspx?key=5a1de8ad-f868-4157-8b5e-34cd0ffc417d)
Workspace Password: Pw0W4H7o8L-l)pLh
Let me know the result if possible.
-lambertLambert Qin | Microsoft Online Support Engineer
How to ask a question in the forum (http://support.microsoft.com/kb/555375)
Posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
May 12th, 2009 10:18am
The real problem here is Internet Explorer. Add the site to your trusted sites list in Tools/Options/Security Tab. Then lower the security of the Trused sites to Low. Then reload the webpage, and it should load fine.
Sunny Lowe
February 9th, 2011 3:46pm