Document Editing Problems

Fix Excel Online Copy and Paste Errors With Formulas

Ayan Masood Sep 29, 2026 871 views

Question details

Users need to resolve an intermittent issue where copying and pasting data that includes formulas fails with a specific retrieval error message in the web browser.

How to Fix Excel Online Copy and Paste Errors When Formulas Are Included

Product: Excel Online
Device & OS: not provided
Scenario: Copying cell ranges containing formulas from one workbook to another within the Excel Online web interface.
Observed behavior: The paste operation fails and displays the message "Retrieving data. Wait a few seconds and try to cut or copy again." The error only triggers for formulas, while plain text values copy normally.

Before you start

Ensure your internet connection is stable and verify whether the error only happens when copying formulas, as network latency can disrupt complex clipboard data transfers in web browsers.

Solution 1Recommended

Clear Browser Cache and Windows Clipboard

Use this solution to eliminate temporary browser glitches and clear overloaded clipboard history that may block formula data transfer.

Excel Online relies heavily on browser resources and the system clipboard to transfer complex formula data. Conflicting browser extensions or a full clipboard can interrupt this process, triggering the "Retrieving data" error.

Open a Private Browsing Window

Launch your browser in Incognito or Private mode to temporarily disable extensions that might interfere with Excel Online's background scripts.

Clear Browser Data

If Private mode works, return to your normal browser window, go to the browser settings, and clear your cache and cookies.

Clear the Windows Clipboard

Press the Windows key + V to open the Clipboard history panel, then click "Clear all" to reset your system's clipboard memory.

Retry Copying the Formula

Go back to Excel Online, highlight the cells containing the formulas, press Ctrl + C to copy, wait a few seconds, and press Ctrl + V to paste.

Supported Browsers: For the best experience with Microsoft 365 web apps, ensure you are using the latest version of Microsoft Edge, Google Chrome, or Mozilla Firefox.

Solution 2

Bypass the Web App by Using Excel Desktop

Open the affected workbook in the local desktop application to avoid web-based synchronization and clipboard limitations.

Free Microsoft Office alternative

Try WPS Office for Reliable Data and Formula Management

If Excel Online continues to struggle with formula copying due to server or network issues, consider switching to WPS Office. It provides a highly compatible, lightweight desktop experience that processes formulas locally, ensuring you never face "retrieving data" delays.

1. Download the Software: Visit the official WPS Office website and download the free desktop installation package.
2. Install and Launch: Run the installer and open WPS Spreadsheet on your device.
3. Edit Files Seamlessly: Open your existing .xlsx workbooks and copy formulas instantly without relying on a web browser or internet connection.

100% free and lightweight desktop suiteSeamless compatibility with Microsoft Excel (.xlsx) formatsHandles complex formulas and large datasets without network lagFamiliar user interface for immediate productivity

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel Online say "Retrieving data" when copying formulas?

This error occurs because Excel Online requires an active connection to Microsoft's servers to calculate and format complex formulas before pasting them. Network latency, browser glitches, or server-side synchronization issues can cause this process to time out.

Does this copy and paste error affect plain text values as well?

Generally, no. Users typically report that copying and pasting small sets of plain values works fine. The "Retrieving data" error is almost exclusively tied to ranges containing formulas or highly complex formatting.

How can I copy my data if the formula keeps triggering an error?

If you only need the calculated results rather than the underlying formula, you can try pasting the data as values. Right-click the destination cell and select "Paste as Values" (or use Ctrl + Shift + V). Alternatively, open the file in a desktop application to bypass browser limitations.

Document & File Issues