sodcalculator

10 Tech How-To

Fix Excel’s “Retrieving Data, Wait a Few Seconds” Error

Guide 10-40405 · Updated · Step by step

The “Retrieving Data. Wait a few seconds and try to cut or copy again” message usually appears when Excel for the web has not finished loading or synchronizing a workbook. These steps help identify whether the cause is a temporary sync delay, a browser issue, or a problem with the workbook, then offer ways to keep working without losing changes.

What You’ll Need

  • A stable internet connection if you are using Excel for the web or a workbook saved to OneDrive or SharePoint.
  • Access to the workbook and, if possible, the desktop version of Excel.
  • A little time to let changes finish syncing. Avoid closing the workbook until you know your latest edits are saved.

Step-by-Step

  1. Wait for the workbook to finish syncing. Stop clicking Cut or Copy for a moment. Check for a saving or syncing indicator near the workbook name or in the status area. Wait until it disappears, then try the action once. If a large range, formula, or data connection is still processing, repeated attempts can make the delay worse.
  2. Check that your connection is steady. Open another webpage to confirm the internet is working. If you are on Wi-Fi, move closer to the router or reconnect. In a work or school network, a temporary connection interruption may prevent Excel from retrieving the current workbook data. Do not refresh or close the workbook while it shows unsaved changes.
  3. Save a safe copy of important work. If the workbook is responsive, use File > Save As to create a separate copy, or download a copy if that option is available. If saving or downloading is not available, wait for sync to complete before making changes that could overwrite the original. Keep the original open until you have confirmed the copy contains your latest edits.
  4. Reload Excel for the web only after checking sync. Once the workbook indicates that it is saved, refresh the browser tab. If Excel asks whether to restore or keep changes, read the prompt carefully and choose the option that preserves the latest version. Reopen the workbook and test copying a small cell range.
  5. Try a private or different browser window. Open the workbook in a private or incognito window and sign in to the same Microsoft account. If the problem stops, a browser extension, cached site data, or a profile setting may be involved. Disable extensions one at a time or clear the browser’s cached data for the relevant site, then retry. Clearing cookies may sign you out, so make sure you know how to sign back in.
  6. Open the workbook in the desktop app. In Excel for the web, use the available Open in Desktop App option, often found under Editing or Open. If prompted, confirm that the desktop app should open the file. In desktop Excel, check that the workbook has finished loading and that changes are saved before copying. If the web version offers no such option, download a copy and open it in Excel, taking care not to create conflicting edits to the original.
  7. Check whether the issue is limited to one workbook. Create a blank workbook and test copying a few cells. If copying works there but not in the affected file, the original may be unusually large, contain complex formulas or connections, or have a temporary sync conflict. Save a separate copy, then test a smaller range or copy one sheet at a time. Avoid deleting connections, formulas, or workbook content unless you understand what depends on them.
  8. Restart the app or browser and update it. After confirming the workbook is saved, close and reopen the browser or Excel. Install available updates for your browser and desktop Excel through the normal update settings. A restart can clear a stuck session, but it cannot recover unsaved changes, so check the save status first.

Common Mistakes

  • Clicking repeatedly. Repeating Cut or Copy while Excel is busy rarely helps. Wait for syncing or processing to finish before trying again.
  • Refreshing before changes are saved. A reload can discard edits that exist only in the current browser session. Confirm the workbook is saved, or preserve a copy first.
  • Assuming the clipboard is the problem. This message often points to Excel for the web retrieving workbook data, rather than a fault with the computer’s clipboard. Test the workbook in another browser or in desktop Excel before changing system clipboard settings.
  • Editing the same file in two places. Working in the browser and desktop app at once can create sync or version conflicts. Choose one version and wait for it to save before switching.
  • Deleting workbook features to speed it up. Removing formulas, links, or data connections can damage how a workbook works. Make a separate copy before testing changes, and ask the workbook owner if it is shared or business-critical.

Tips

  • Copy a smaller range first. If it works, split a large selection into manageable sections.
  • Use Copy instead of Cut when possible. Copying leaves the source in place while you confirm the destination is correct.
  • For a one-time transfer, paste values when appropriate. In Excel, use the paste options or Paste Special in the desktop app, but remember that values will not retain formulas.
  • When working with a shared file, tell collaborators before restarting or moving between app versions. This helps avoid simultaneous edits and conflicting copies.
  • Keep a separate backup of important work, especially before troubleshooting a large or complex workbook.

Troubleshooting

The error returns after refreshing: Wait for the saving indicator to clear, then test in a private window or another supported browser. If the same workbook fails everywhere, try opening a copy in desktop Excel.

The desktop app also cannot copy: Check whether Excel is still calculating or loading data. Try a small range in a blank workbook. If that works, the issue is likely specific to the workbook or its current session; save a copy and narrow down which sheet or range triggers it.

You cannot tell whether the latest edits are saved: Do not close the file or choose an option that discards changes. Wait for the status to update, check the file’s recent activity or version history if available, and ask the owner of a shared workbook to confirm the current copy before proceeding.

Several people are affected: The problem may be related to access, synchronization, or a temporary service interruption rather than your browser. Ask another workbook user to check, and consult your organization’s Microsoft 365 administrator if the file is managed by work or school.

The error happens in every workbook: Update and restart the browser or Excel, then test another browser or device. If the problem persists across devices, contact your administrator or Microsoft support and include the app you are using, what action triggers the message, and whether it affects other files.

Frequently Asked Questions

What does “Retrieving Data, Wait a Few Seconds” mean in Excel?
Excel for the web has not finished retrieving or synchronizing the workbook data needed for the requested action. Waiting for the save or processing activity to finish is the safest first step.

Is this error usually caused by my clipboard?
Not necessarily. The wording commonly appears when Excel for the web is unable to retrieve workbook data promptly. Testing in another browser or the desktop app can help distinguish a workbook or sync issue from a local clipboard problem.

Can I fix it by clearing the browser cache?
Sometimes. First confirm the workbook is saved. Then try a private window; if that works, clear cached site data or disable extensions. Clearing cookies may sign you out.

Will refreshing the page delete my changes?
It can discard edits that have not synced. Check the save status first and preserve a copy if possible. Do not refresh while Excel indicates that changes are still being saved.

Should I use Excel for the web or the desktop app?
Try the desktop app if the web version continues to show the message, especially for a large or complex workbook. Confirm that your edits are saved and avoid making simultaneous changes in both versions.

What if it happens only with one shared workbook?
Test a separate copy and a small range, and ask the workbook owner whether others see the same issue. A sync conflict, workbook complexity, or shared editing activity may be involved.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →