SharePoint Export to Excel Not Working: Troubleshooting Tips

Top fixes to troubleshoot the export to Excel feature in SharePoint

by Henderson Jayden Harper
Henderson Jayden Harper
Henderson Jayden Harper
Passionate about technology, Crypto, software, Windows, and everything computer-related, he spends most of his time developing new skills and learning more about the tech world. He also enjoys... read more
Reviewed by Alex Serban
Alex Serban
Alex Serban
Windows Server & Networking Expert
After moving away from the corporate work-style, Alex has found rewards in a lifestyle of constant analysis, team coordination and pestering his colleagues. Holding an MCSA Windows Server... read more
Affiliate Disclosure
  • Exporting the SharePoint list to Excel not working can be due to Excel timeout being exceeded.
  • A non-32-bit browser for SharePoint can cause issues exporting data to Microsoft Excel.
  • Signing out and into Excel can fix the issue.
sharepoint export to excel not working

XINSTALL BY CLICKING THE DOWNLOAD FILE
To fix various PC problems, we recommend Restoro PC Repair Tool:
This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues and remove viruses now in 3 easy steps:

  1. Download Restoro PC Repair Tool that comes with Patented Technologies (patent available here).
  2. Click Start Scan to find Windows issues that could be causing PC problems.
  3. Click Repair All to fix issues affecting your computer's security and performance
  • Restoro has been downloaded by 0 readers this month.

SharePoint is a web-based collaboration platform for managing documents and is also used to build an organization’s intranet, etc. However, users report the SharePoint export to Excel is not working, making it difficult to send out documents or items from SharePoint.

Why should you want to export SharePoint data to Excel

SharePoint has many features that make it convenient to navigate and use. One of the most notable features is that SharePoint allows users to export and share their document libraries.

Furthermore, due to the recent updates on SharePoint, moving list libraries have become accessible and more intriguing. Some data you can export from SharePoint to Microsoft Excel are: a list created from a template, any app created that’s a list and Metadata in document libraries.

However, the main reason for exporting SharePoint list items to Microsoft Excel is to work with the data in a workbook. It allows you to access and work with the information created in SharePoint on Excel.

Why am I unable to export to Excel from SharePoint?

Using the Export to Excel button in SharePoint can sometimes run into an error stating that an unexpected error occurred. Changes to your data cannot be saved. It can occur for many reasons. Some are:

  • Timeout of this client is exceeded – Excel has a 55-second timeout when importing data from SharePoint. The time allows it to load the data exports from SharePoint. So, you may be unable to export from SharePoint to Excel or run into errors if the timeout of this client is exceeded.
  • Issues with the browser – Since you’re using SharePoint online, you can run into errors exporting to Excel using a non-32-bit browser.

Other factors may be responsible for the error on your PC. Hence, we’ll take you through some troubleshooting tips for fixing the issue.

What can I do if SharePoint cannot export to Excel?

Before proceeding with any advanced troubleshooting steps, go through the following preliminary checks:

  • Fix network congestion on your PC.
  • Stop any download process on your browser.
  • Switch Browser for SharePoint – We recommend you switch to a 32-bit version of Internet Explorer. It is the best browser to use SharePoint with, and it supports ActiveX controls, which aid the smooth use of SharePoint.

If the error persists, follow the solutions below:

1. Increase the default Excel timeout value by using a Registry key

  1. Press Windows + R key to open the Run dialog box, type regedit, and click OK to open Registry Editor.
  2. Click Yes if prompted by UAC.
  3. Copy and paste the following registry path: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Microsoft\Office\16.0\Access Connectivity Engine\Engines
  4. Go to the Edit menu, click on New and select DWORD Value.Locate Excel engine inregedit
  5. Type DataFetchTimeout and press Enter. Right-click the DataFetchTimeout entry, then select Modify from the drop-down.modify Engine settings
  6. Select Decimal for Base, type 90000 in the Value data box, then click OK.set value to 90000
  7. Close the Registry Editor and restart the export process.

Increasing the default Excel timeout value gives the export process more time to execute. Read how to fix error accessing the Registry if you run into problems using the Registry Editor.

2. Sign out and sign in to Excel

  1. Open Excel on your PC, click the Account link, and click on Sign out at the top of the screen.
  2. Exit the Excel app.
  3. Navigate to your SharePoint list and click the Export to Excel button.
  4. Launching Excel should prompt you to sign in with an account and enter your login credentials.

Signing back into Excel will prompt the list data to load and display in Excel.

Another issue users complain about is SharePoint not opening Excel or Word documents for some reason.

Alternatively, our readers can check our guide on how to fix Excel’s sharing violation error with these easy fixes. Also, we have a detailed article about a problem connecting to the server error preventing the Excel spreadsheet from being imported.

In conclusion, this guide should help you troubleshoot the SharePoint export to Excel not working problem. If you have further questions or suggestions, kindly use the comments section.

Still having issues? Fix them with this tool:

SPONSORED

If the advices above haven't solved your issue, your PC may experience deeper Windows problems. We recommend downloading this PC Repair tool (rated Great on TrustPilot.com) to easily address them. After installation, simply click the Start Scan button and then press on Repair All.

This article covers:Topics: