A ‘gotcha’ when importing lists from Excel to SharePoint

by on
in Office Technology,Web Tools

There is a “gotcha” when importing lists from Excel to SharePoint. After selecting the file to import, a message may appear that says, “The specified file is not a valid spreadsheet or contains no data to import.”

Before spending hours trying to fix a file that’s not broken, all you have to do is add your SharePoint site to Trusted Sites in the security tab of your browser. While the message doesn’t seem to reveal that this is the problem, it will likely fix it immediately. You won’t even need to restart your browser.

{ 2 comments… read them below or add one }

Rohit Sharma January 22, 2013 at 1:36 pm

Learning sharepoint is a great way to safeguard your future. Sharepoint 2013 would be a landmark for Microsoft. Get more info and training on Sharepoint at http://bit.ly/Q9hMKw

Reply

Teckmea January 18, 2013 at 9:12 pm

Learn how to virtualize enterprise applications including Exchange, SQLServer, SharePoint and SAP. Join this webinar on January 23, 2013. RSVP Today! http://bit.ly/Cloud-webinar

Reply

Leave a Comment