Export To SharePoint List - An Unexpected Error has occurred

Question

Hello,

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

Answer 1

I managed to do it finally. The issue was corrupted Office files apparently. I tried re-installing it worked. Thank you for your support.

Answer 2

Hello,

Thank you for your response.

This is my Office Version:

I have tried your first suggestion. I can import tables using that function. However, it's not what I need. I'll use VBA for my specific needs and I need that option to work.

Could you elaborate this a bit?

"this issue also occurred even created a dummy file with a dummy table, could you Please confirm if the issue only happens in the specific SharePoint online list? Or all SharePoint list."

I'm not sure what's the difference between SP Online list and All SharePoint Lists?

We've got only one SP domain.

Answer 3

Hi Berat Barış Kuzu,

Thanks for your valuable feedback, glad to hear this issue has been resolved and the issue cause by corrupted Office files and after re-installing it worked for you. Thanks for sharing updates with us. I will mark your reply and It will benefit for other members who have similar issue in this community.

If there is any issue related with the Office applications in the future, please feel free to post back in this community.

We will be here for help.

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Best regards

Waqas Muhammad

Answer 4

Hi Berat Barış Kuzu,

First, my pleasure to assist you.

As per your description, please don’t worry, we can work together to narrow down and resolve the situation.

It seems you are unable to Export SharePoint online list data in to Excel on your machine/pc and you tried all mentioned suggestion in your post but still issue persist.

If my understanding is right, for the situation you encountered, we do understand the inconvenience caused and apologize for it. And we just tested from our side, and it seem we can Export Excel data table into SharePoint online list data without any issue.

Here is my test screenshot for your reference:

To check if this issue related with SharePoint list, could you please try to Export your Excel data table via Create a list based on a spreadsheet

Meanwhile, to narrow down your issue, please tell us more information below to let us help you:

1. Since you mentioned, this issue also occurred even created a dummy file with a dummy table, could you Please confirm if the issue only happens in the specific SharePoint online list? Or all SharePoint list.

2.To confirm whether this is a bug in a specific version, please provide us the version information. To check version: Open Excel>File>Account>Product Information and capture a full screenshot and share here (Please mask your private information) and we will be tested on that version and verify the result with you.

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Best regards

Waqas Muhammad