If you’ve ever tried copying data from an Excel Online sheet into your desktop version of Excel and been met with the message —
“Retrieving data. Wait a few seconds and try to cut or copy again” — you’re not alone.
This error has frustrated thousands of Microsoft Excel users, especially those working across Excel Online, OneDrive, and Office 365 environments. The issue seems random at first, but it has specific causes and predictable fixes once you understand what’s happening under the hood.
In this guide, you’ll learn why this error occurs, what it means technically, and how to fix it permanently — not just temporarily.
What Does “Retrieving Data. Wait a Few Seconds…” Actually Mean?
This message usually pops up when Excel is unable to access the copied data stored in your clipboard. When you copy something in Excel Online, it doesn’t behave like your local clipboard — instead, it temporarily holds the data through your browser’s cache and Microsoft’s cloud sync (OneDrive/Office 365).
If your internet connection stutters or the sync lags, Excel can’t fetch that copied data fast enough when you paste it into the desktop version. So, Excel shows this “retrieving data” message, essentially saying — “I can’t access what you just copied; please try again.”
This behavior is more common when:
- You copy large data ranges from Excel Online.
- You’re connected to a slow or unstable network.
- OneDrive or Office 365 sync is delayed.
- The workbook is shared or co-authored by multiple users.
Microsoft hasn’t released a dedicated patch for this yet, but several consistent workarounds have proven effective.
Why This Error Keeps Appearing
From experience, this error is less about Excel being “buggy” and more about how Excel Online manages clipboard data. The online version doesn’t have direct access to your system clipboard. Instead, it sends clipboard data through your browser session — which relies on cache, cookies, and network response time.
When that connection breaks, the copied data becomes temporarily unavailable. You may notice this happening particularly when:
- Switching from Chrome or Edge tabs during copy-paste.
- Copying data from one workbook to another in different browser windows.
- Using Excel Online while your PC’s Excel Desktop is already open in the background.
So, while the message sounds harmless, it’s essentially telling you Excel can’t “see” the data anymore.
Quick Fix: Deselect and Copy Again
Let’s start with the simplest method — and surprisingly, it works more often than you’d think.
After getting the message, unselect the copied cells, wait about 5–10 seconds, and copy them again.
This resets the temporary clipboard state in Excel Online and often allows a successful paste afterward.
However, if you work on shared sheets or deal with frequent copy-pasting between Excel Online and Desktop, this is just a short-term fix. You’ll want a more permanent solution.
Permanent Fix: Download and Open the File in Excel Desktop
If you regularly copy data from Excel Online into your local Excel, the most reliable approach is to stop relying on the web clipboard altogether. Instead, download the workbook and use the desktop version directly.
Here’s how to do it properly:
- Open your workbook in Excel Online.
- Go to File → Save As → Download a Copy.
- Save it locally and open it in your desktop version of Microsoft Excel.
- When prompted, click Enable Editing to unlock full functionality.
Once opened locally, you can copy, cut, and paste without the “Retrieving data” delay — because Excel Desktop doesn’t depend on browser-based caching or cloud clipboard services. Everything runs through your PC’s RAM, which is faster and more reliable.
In my testing across Excel 365, 2021, and 2019, this permanently eliminates the issue as long as the file stays local.
Why Excel Online Clipboard Fails — The Technical Side
If you’re curious about why this issue persists, it comes down to how Microsoft 365’s cloud clipboard works.
When copying in Excel Online:
- Your selected data is stored in your browser cache as a temporary payload.
- The clipboard data passes through OneDrive’s sync layer if the file is stored there.
- The desktop version of Excel then tries to fetch that data using your signed-in Microsoft account.
If any step in that chain — browser cache, authentication, or network transfer — fails, the payload can’t be retrieved. Hence, Excel tells you to “wait a few seconds.”
The irony is, even if you wait, the data may have already expired from the cache. That’s why repeated attempts don’t help — you have to re-copy the data to refresh the cache token.
Fix 3: Clear Cached Files and Browser Data
If you consistently see this message, your browser’s cache may be holding outdated data from Excel’s clipboard sessions. Clearing it can help Excel Online refresh its cache pipeline.
To do this:
- Press Ctrl + Shift + Delete in your browser.
- Choose All time as the time range.
- Select only Cached images and files.
- Click Clear data.
Once done, restart your browser, sign back into Office.com, and re-open the same Excel file. Try the copy-paste again — it should work cleanly if cache corruption was the root cause.
Fix 4: Use a Different Browser
Some browsers handle clipboard APIs differently. For example, Edge and Internet Explorer (legacy) often struggle with Excel’s cloud clipboard because of stricter security sandboxing.
Switching to Google Chrome or Mozilla Firefox usually resolves the issue instantly. These browsers handle JavaScript clipboard events more consistently with Excel’s web app.
If your workflow involves multiple tabs or shared links, Chrome tends to maintain clipboard stability better than Edge — especially for large or multi-cell copies.
Fix 5: Turn Off AutoSave in OneDrive or SharePoint
Here’s one that most tutorials miss.
When working with a cloud-stored workbook (OneDrive or SharePoint), AutoSave can trigger background sync operations while you’re copying data. This interrupts the clipboard token Excel Online uses.
To disable it temporarily:
- Open the workbook in Excel Desktop.
- Toggle AutoSave off (top-left of your Excel ribbon).
- Try your copy-paste operation again.
Once done, you can enable AutoSave again. You’ll likely notice that the “Retrieving data” message disappears when AutoSave is off — confirming that the issue came from background sync delays.
Fix 6: Copy in Smaller Batches
If you often deal with large datasets (thousands of rows or multiple columns), Excel Online may struggle to transfer that much data through your browser’s limited memory buffer.
Try copying smaller portions of the data first. For instance, instead of selecting the entire range, copy 200–300 rows at a time. You’ll find the copy-paste process becomes much smoother and the retrieval message rarely appears.
This also helps prevent the clipboard from timing out mid-transfer — a common hidden cause for the delay message.
Fix 7: Temporarily Save and Reopen the Workbook
Another practical workaround is to simply save the workbook, close it, and reopen it before retrying the copy. This clears Excel’s temporary background sessions and reinitializes the clipboard state.
Especially when you’ve been editing for a long time or have multiple co-authors, Excel Online can accumulate session data that causes the clipboard link to fail.
Reopening the file refreshes that session without you having to clear cache or switch browsers.
Related Excel Copy-Paste Issues You Should Know
If you’re troubleshooting this error, it’s worth being aware of a few related ones that often appear together:
- “The data you’re pasting isn’t the same size as your selection.”
- “Cannot paste the data.”
- “Excel cannot complete this task with available resources.”
All of these are part of Excel’s broader clipboard system. Once you understand how Excel Online and Desktop exchange data, you can diagnose them more easily.
For instance, “Cannot paste the data” usually happens when format mismatches occur, while “available resources” errors point to memory limits on large datasets.
If you start encountering any of these after the “Retrieving data” message, you’re likely dealing with a broader Excel clipboard or memory issue rather than just network sync.
Frequently Asked Questions (FAQs)
1. Why does Excel say “Retrieving data. Wait a few seconds and try to cut or copy again”?
This message appears when Excel Online loses access to the data you copied — usually due to a slow internet connection, expired browser session, or cloud sync delay. Excel stores clipboard data temporarily in the browser cache, and when that data expires or becomes unavailable, it can’t complete the copy-paste action. You’ll need to recopy the data or refresh your Excel session.
2. Does this issue occur in Excel Desktop too?
It’s mostly limited to Excel Online. The desktop version manages clipboard data locally, so you rarely see this message there. However, if you do, it usually indicates a local clipboard failure or a background add-in causing interference.
3. How can I fix the “Retrieving data” error permanently?
The most effective solution is to download the workbook and open it in the desktop version of Excel. Local copies don’t depend on cloud sync, eliminating clipboard delays.
If you prefer using Excel Online, try clearing your browser cache, keeping a stable internet connection, and avoiding tab switching during copy-paste.
4. Does clearing browser cache actually help?
Yes. Excel Online uses your browser cache to store temporary clipboard data. If it becomes corrupted or full, Excel may fail to retrieve the data. Clearing cached files resets that temporary memory, allowing copy-paste to work normally again.
5. Can slow Wi-Fi or VPN cause this error?
Absolutely. A weak or throttled connection — especially through VPNs — can interrupt Excel’s cloud sync, leading to the “retrieving data” message. Disabling VPN temporarily or switching to a faster network usually resolves this.
6. What’s the difference between “Retrieving data” and “Cannot paste the data”?
They’re related but distinct.
- “Retrieving data…” appears when Excel can’t access the copied data from cache or cloud.
- “Cannot paste the data” appears when the data is fetched but doesn’t match the format or size of the target cells.
Knowing the difference helps you pinpoint whether the problem lies in connectivity or formatting.
7. Is Microsoft planning to fix this issue officially?
Microsoft has acknowledged the problem in community forums but doesn’t classify it as a formal bug. It’s a side effect of how Excel Online syncs clipboard data through the cloud. For now, the only reliable workaround is using the desktop version for large copy-paste operations.
8. Can I use Excel’s Clipboard Manager to avoid this problem?
Yes. Turning on Office Clipboard Manager (Home → Clipboard) stores multiple copied items locally, reducing dependency on browser cache and preventing quick clipboard expiry. It’s especially useful for users switching between Excel Online and Desktop versions.
Final Thoughts: Why Your Fix Should Be Permanent
If your goal is to eliminate this issue permanently, stop copying directly from Excel Online to Desktop Excel. Always work from a downloaded local copy or ensure your internet and cache environments are stable.
From long-term observation, the root of this problem isn’t user error — it’s the inherent delay in how Office 365 handles clipboard data between web and desktop environments.
By downloading your file or switching browsers, you bypass the fragile web-to-desktop clipboard layer that causes the problem.
After applying these methods, you should no longer see “Retrieving data. Wait a few seconds and try to cut or copy again” — and you can get back to focusing on your actual work instead of fighting Excel.
Key Takeaway
When Excel says “Retrieving data…”, it’s not broken — it’s just waiting for a connection that often won’t return.
Once you understand what’s happening behind the scenes — clipboard caching, OneDrive delays, or browser memory issues — the fixes become simple and reliable.
If you work with Excel daily, bookmark this guide. The next time Excel slows you down with that dreaded message, you’ll know exactly what to do — and why it works.
