SP 2010: User cannot import spreadsheet or export list to spreadsheet

Problem: Site owner receives the following error when trying to use the ‘Import Spreadsheet’ option to create a list from Excel within SharePoint. Same error when trying to export existing list to Excel.

Note: although this worked in this specific scenario, it may not work in others. There are a lot of variables that I did not have time to drill down into, but lucky for me, the issue was resolve

– Verified user was using Excel 2010 32bit

– User was on a 64-bit machine

– Had the user download and install 2007 Office Data Connectivity Components: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734

– Problem was still happening

– Had the user to an Office Detect & Repair and that solved the problem

Fight Comparison:

Morales Vs. Barrera III, both got the best of each other, but Barrera finally figured him out and turned it up in the last round.

Comments (0)