Shulou(Shulou.com)06/03 Report--

Exporting to Excel is a useful SharePoint feature. Occasionally you may encounter situations where this feature does not work properly. There are several reasons why this feature may not work properly.

Problem # 1

Use non-32-bit Internet Explorer

Solution # 1

Make sure you are using the 32-bit version of Internet Explorer. As pointed out in the previous article for SharePoint Server 2016 Web browser support, other browsers (Microsoft Edge,Chrome,Firefox,Safari, etc.) do not support ActiveX controls

Problem # 2

If you receive an error to export the list, you must have an Microsoft SharePoint Foundation compliant application.

Solution # 2

This error may be because you are running multiple versions of Microsoft Office on the same computer. For example, you may have installed Office 2016 but installed SharePoint Designer 2013. Because SharePoint Designer is indeed an Office component, you are running multiple versions of Office. Multiple versions of Office cause a lot of errors. The solution is to make sure that you are running only one version of Office. In some cases, you may have to completely delete multiple versions, restart your computer, and then install only one version.

Problem # 3

Exporting to Excel does not work when using custom lists. This is a known problem in SharePoint. For this and other reasons, many people avoid using custom lists in SharePoint

Solution # 3

The solution is to avoid using special characters when using custom lists. You may encounter this problem whether you use a custom list or not. Avoid using special characters in column names, such as #, @,%, etc. Before you can export a list to Excel, you may have to delete the column and recreate it without using special characters.

Problem # 4

You have tried other solutions, but still cannot export the SharePoint list to Excel

Solution # 4

Review the add-ins in the browser and make sure that all Office and SharePoint-related add-ons are enabled. In particular, make sure that the SharePoint Open document class is enabled. This attachment is used for various SharePoint functions. In Internet Explorer, go to tools-> manage add-ins and verify two things. First verify that the Microsoft Office and SharePoint add-ins are enabled. Then verify that the schema column is 32-bit.

Problem # 5

An unexpected error occurred when you received the error. Your data changes cannot be saved. You may encounter this error when using an unsupported browser, or when exporting a very large list of thousands of entries.

Solution # 5

Suppose you have 10000 items in the list. Use the all projects view and change the view to display fewer items, such as 1000 or 700, and then try to export the list. You may need to try different numbers to make it work.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.