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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics