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
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.