Forum Discussion

kheldar's avatar
kheldar
Iron Contributor
May 19, 2022

Export To SharePoint List - An Unexpected Error has occurred

Hello,

 

I wasn't sure if I should create this topic in SharePoint section but since I'm getting this error on Excel, I've decided to create it here.

 

I'm trying to get started with SharePoint lists. However, I have hit a road block before even starting.

 

I've googled extensively before creating this thread. None of the articles were helpful and I gave up on Google.

Details:

I created a dummy file with a dummy table. No special characters anywhere. Uploaded it my SP. This is the error I get when I try to export the table to SP Lists.

 

I then contacted my IT to check if I had permission. I didn't. Then I was granted permission. I can create lists manually on SP. I can even import Excel files with tables through the browser.

 

However, I still get the same error using Excel. Since the error doesn't indicate anything else I couldn't expand my research.

 

What I've tried so far:

 

  • Sign out and sign in.
  • Removed my credentials from Credentials Manager on Windows and sign in again
  • Tried changing file format to XLSM or XLSX
  • Made sure there are no special characters in the table headers.
  • Validated my SharePoint address through my IT. I can also access my SP using PowerQuery with the same URL.
  • Unmarked "Ignore other applications that use Dynamic Data Exchange (DDE)" in Excel options
  • Ran gpupdate /force through elevated command prompt.

Note:

I'm accessing my SharePoint using OneDrive.

 

I'm in need your assistance.

 

Thanks.

 

 

 

 

 

No RepliesBe the first to reply

Resources