Data Import & Export

Fix "Unexpected Error" When Exporting Folder Info to Excel

Khadija Khan Oct 9, 2026 870 views

Question details

The user is unable to export file names from a folder to Excel and receives a specific unexpected error message preventing data from being saved.

How to Fix Excel Export Error for Folder Information

Product: Excel
Device & OS: not provided
Scenario: Exporting folder information or file names from a document library to an Excel spreadsheet.
Observed behavior: The system displays the error message: "An unexpected error has occurred. Changes to your data cannot be saved."

Before you start

Before troubleshooting, verify that your account has the necessary permissions for the specific folder or document library you are trying to export.

Solution 1Recommended

Diagnose Library and Permission Issues

Perform a series of diagnostic checks to determine if the issue is isolated to a specific library, account permissions, or the Excel application itself.

Export errors of this nature are often tied to SharePoint or document library permission glitches rather than the Excel application itself. Isolating the variable will help determine the correct fix.

Test alternative libraries

Navigate to a different folder or document library and attempt the 'Export to Excel' function to see if the issue persists across all libraries or is isolated to just one.

Verify account permissions

Check your library settings to ensure you have at least 'Read' and 'Open Items' permissions. Contact your IT administrator to confirm your profile has export rights.

Check with other users

Ask colleagues who have access to the same folder to perform the export. If they succeed, the issue is tied to your specific account profile or local Excel installation.

Document the exact error

Take a screenshot of the error message when it appears. This is crucial for IT support to identify whether the export service or the local Excel cache is failing.

Clear Local Cache: If the issue is isolated to your computer, try clearing your Excel cache by navigating to File > Options > Save, and clicking 'Delete cached files'.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

If you continuously face export errors and connectivity crashes in Microsoft Excel, consider switching to WPS Office. It is a lightweight, highly compatible alternative that lets you manage, analyze, and save data without unexpected interruptions.

1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite on your computer.
2. Open WPS Spreadsheets: Launch WPS Office and click on 'Spreadsheets' to open a new or existing workbook.
3. Manage Your Data: Import your downloaded folder data directly into the spreadsheet to organize and save it without compatibility issues.

Fully compatible with Microsoft Excel (.xlsx and .xls) formatsLightweight design ensures fast loading and stable performanceFamiliar interface makes switching easy with zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel say changes to my data cannot be saved when exporting?

This usually occurs when there is a disconnection between the source document library (like SharePoint) and the local Excel application, often caused by expired login tokens, insufficient permissions, or a corrupted local cache.

Can insufficient permissions cause Excel export errors?

Yes. If your user account does not have the correct viewing or downloading privileges for the specific folder or library, the server will block Excel from saving the queried data, triggering an unexpected error.

How can I export file names from a folder without using the library export button?

You can use Excel's Power Query feature. Go to the Data tab, select 'Get Data', then 'From File', and choose 'From Folder'. Browse to your folder and click 'Open' to load the file names and metadata directly into your spreadsheet.

Excel & Data Problems