skip to Main Content

One of the most interesting ways to create and populate a SharePoint list is to use the Import Spreadsheet from Excel. Unfortunately, I received and weird error message: An unexpected error has occurred. (-2147467259).

Error

I’ve done some research, but found nothing. So, I decided to ask the guys from the O365 community:  Unable to create SharePoint list from Excel file
The proposed solutions didn’t worked, so I kept insisting and testing, until I found the solution.

My system specifications

On my laptop I had:

  • Windows 8 Enterprise 64 bit;
  • Office 2013 Pro Plus 32 bit;
  • Internet Explorer 10 64 bit.

What did I tried?

  • I’ve enabled/disabled the Enhanced Protected Mode option, so I can change my browser from 32 bits to 64 bits, but without any luck;
  • I’ve re-added the SharePoint site into the Trusted Sites, without any result;
  • I’ve done some testing on a system with Windows XP and IE, all on 32 bits, with success.

After the last test, it seemed that it was a browser problem, so I’ve analyzed the dll’s that Office 2013 Pro Plus had installed in IE, in order to enable communication between the browser and the SharePoint site.

I knew  from the community that the SharePoint OpenDocuments Class add-on is responsible with that communication.

Then, I noticed that those add-ons had only the 32 bit version.
Because I had a 64 bit OS I decided to try the Office 2013 Pro Plus the 64 bit version.

How to fix -2147467259 error?

  • unnistal Office 2013 Pro Plus the 32 bit version.
  • download and install Office 2013 Pro Plus the 64 bit version.

OWSSUPP.DLL

After the installing process has ended, I was able to import and Excel workbook into SharePoint and to create a new list.

(Visited 32 times, 1 visits today)

Cosmin Tătaru

Pasionat de blogging și tehnologie încă din 2009, Cosmin este aici să vă ajute să vă creșteți vânzările și productivitatea punând tehnologia la treabă pentru dumneavoastră.

Suport-Clienti
Mergeți sus