How to Fix Excel Freezing When Copying SharePoint Data
Question details
The user experiences worksheet freezing and unresponsiveness when attempting to copy and paste data inside an Excel workbook that is connected to SharePoint lists via manual references.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Copying more than two cells at a time in a workbook containing hyperlinked SharePoint files and manual data references (owssvr exported lists).
- Observed behavior
- Excel completely freezes or becomes highly unstable when copying multiple data cells after source files gain additional rows.
Verify your network connection to ensure you have stable access to your SharePoint server, and take note of which specific SharePoint lists or files are actively linked to your current workbook.
Perform an Office Online Repair
Use the Windows built-in repair utility to fix potentially corrupted Office installation files that cause Excel to freeze during complex data operations.
Software corruption within Microsoft Office can prevent Excel from properly managing memory during clipboard operations, especially when network connections are involved. An Online Repair replaces all corrupted files with fresh versions directly from Microsoft's servers.
Close all running Microsoft Office applications, press the Windows key, type 'Control Panel', and press Enter.
Click on 'Programs' and then select 'Programs and Features' to view your installed applications.
Scroll through the list to find 'Microsoft Office'. Right-click on it and select 'Change' from the context menu.
Select 'Online Repair' from the dialog box and click 'Repair'. Follow the on-screen prompts and wait for the process to complete before restarting your computer.

Replace Manual References with Power Query
Transition away from fragile manual cell references by importing your SharePoint data securely using Excel's Power Query feature.
Pre-open Connected Source Files
Open the linked SharePoint source files in the background to temporarily bypass the freezing issue while copying data.
Experience Faster Data Processing with WPS Office
If Microsoft Excel continues to freeze during heavy network-connected tasks, consider switching to WPS Office. It provides a highly compatible, lightweight spreadsheet application designed to handle large datasets and everyday data entry smoothly without freezing.
- 1. Download and Install: Visit the official WPS website to download the lightweight, free installation package.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files directly to resume your work.
- 3. Process Data Effortlessly: Perform your complex copy, paste, and find-and-replace operations smoothly without performance drops.

Frequently Asked Questions
Why does Excel freeze when copying data from a connected SharePoint list?
When copying data in a workbook with manual references to a SharePoint list, Excel attempts to continuously validate and recalculate the network paths. If the dataset grows large or the connection is slow, the application becomes overwhelmed with background requests and freezes.
How can I check my current SharePoint data connections in Excel?
Navigate to the 'Data' tab on the Excel ribbon and click on 'Queries & Connections'. This will open a side pane displaying all active connections and linked data sources currently affecting your workbook.
Is Power Query better than manual references for SharePoint data?
Yes, Power Query is highly recommended over manual cell references. It provides a robust, centralized connection to SharePoint online services, allowing you to import, clean, and update large datasets without heavily impacting your workbook's performance.
Will clearing the Office cache help stop the freezing?
Sometimes clearing the Office Document Cache can resolve sync-related freezes. You can do this by opening the Office Upload Center (or going to File > Options > Save in newer Excel versions) and selecting 'Delete cached files'.




