“检索数据(Retrieving Data)。等待几秒钟,然后再次尝试剪切或复制”错误自该应用程序首次启动以来一直困扰着Excel在线用户。当您将复制的数据从Excel工作表粘贴到另一个应用程序时,会出现此问题。当您将内容从Microsoft Excel 联机(Microsoft Excel online to Excel for desktop)复制到 Excel 桌面版时,也会发生这种情况。
Excel不会显示您尝试复制的数据,而是显示消息“正在检索数据(Retrieving Data)” 。等几秒钟。(Seconds.)” 但此消息不会在新对话框中打开,而是显示在Excel本身中。你的工作将会停止,但别担心。这个错误很容易在几秒钟内解决。
什么是“检索数据(Retrieving Data)” 。等几秒钟” Excel中的错误?
该错误似乎是由于某些内部Microsoft Excel错误或您的操作系统问题而发生的,但事实并非如此。“检索数据(Retrieving Data)。等待几秒钟”消息由于数据同步过程而弹出。Microsoft Office 程序(Microsoft Office programs)最初只是为离线使用而开发的。他们没有将其用途扩展到在线世界的功能。
微软(Microsoft)为备份数据实施了数据同步过程。每次您在Excel网络应用程序中进行更改时,数据都会存储在在线服务器上。当您尝试剪切和粘贴时,数据会经过验证过程。这个过程可能会失败;如果发生这种情况,您将看到完整形式的消息:“检索数据(Retrieving Data)” 。等待几秒钟,然后再次尝试剪切(Cut)或复制(Copy Again)。”
尝试不同的浏览器
体验大部分“检索数据”的两个浏览器。等待几秒钟并尝试再次剪切(Cut)或复制(Copy Again)”错误是Microsoft Edge和Internet Explorer。如果您使用其中一种浏览器并继续遇到此问题,请尝试安装不同的网络浏览器(installing a different web browser)。有很多选择,但Mozilla Firefox和Google Chrome始终是安全的选择。
下载(Download)文档(Document)的离线副本(Offline Copy)
您可以下载文件的脱机副本,而不是坚持尝试在联机版Excel中修改文档。(Excel)然后,您可以在桌面Excel应用程序中打开它并在那里进行修改。这是如何做到的:
- 打开您尝试修改但显示此MS Excel错误
的Excel文件。(Excel)
- 选择文件,然后另存为。
- 选择下载副本。
- 像往常一样在桌面应用程序上打开文件。
无论您使用的是 PC 还是智能手机,都需要安装离线版本的Excel应用程序才能打开下载的副本。Windows PC 用户可以在Microsoft Store中找到该应用程序,Android用户可以在Google Play Store中找到该应用程序,而 iOS 用户可以在Apple Store中找到该应用程序。
取消选择(Deselect),等待,然后(Wait)再次(Again)尝试复制
有时,修复检索数据错误所需要做的就是重复您的操作。这意味着您应该再次尝试剪切和复制数据。但首先,请确保取消选择您尝试复制的所有字段。取消选择所有内容后,至少等待几秒钟,然后重试。这使Excel程序有时间处理数据并完成同步。
接下来,尝试再次选择要复制和粘贴的所有字段。使用Excel 键盘快捷键(Excel keyboard shortcuts)来执行此操作并优化您的工作流程。
您也可以尝试使用外部应用程序来粘贴数据。您可能需要重复这些步骤几次才能解决错误。
这些都是修复“检索数据等待(Retrieving Data Wait)几秒钟并再次尝试剪切(Cut)或复制”错误的临时解决方案。由于问题的性质,没有永久的解决方案。但是,所有这些修复都是快速的,可以让您不受干扰地继续工作。因此,请继续尝试其他网络浏览器,或在桌面版Excel(Excel)中打开下载的文件。
但是,如果您找到其他可行的解决方案,请在下面的评论部分告诉我们!
How to Fix “Retrieving Data. Wait a Few Seconds” Error in Microsoft Excel
The “Retrieving Datа. Wait a Few Seconds and try to cut or copy agаіn” error has been bugging Exсel online users since the аpp first launched. The issue appearѕ when you paste copіed data from the Excel worksheet to another aрp. It can alsо occur when you copy content from Microsoft Excel online to Excel for desktop.
Instead of displaying the data you were trying to copy, Excel shows the message “Retrieving Data. Wait a Few Seconds.” But this message doesn’t open in a new dialog box but is displayed inside Excel itself. Your work will come to a halt, but don’t worry. This error is easy to solve in only a few seconds.
What is “Retrieving Data. Wait a Few Seconds” Error in Excel?
The error might seem to happen due to some internal Microsoft Excel bug or a problem with your operating system, but this is not true. The “Retrieving Data. Wait a Few Seconds” message pops up due to the data syncing process. Microsoft Office programs were, at first, developed for offline use only. They didn’t have the features that extended their use into the online world.
Microsoft implemented the process of data synchronization for backing data up. Each time you make a change in the Excel web app, the data is stored on an online server. When you try to cut and paste, the data goes through the validation process. This process can fail; if that happens, you’ll see the message in its complete form: “Retrieving Data. Wait a Few Seconds and Try to Cut or Copy Again.”
Try a Different Browser
The two browsers that experience most of the “Retrieving Data. Wait a Few Seconds and Try to Cut or Copy Again” errors are Microsoft Edge and Internet Explorer. If you use one of these browsers and continue experiencing this issue, try installing a different web browser. There are many to choose from, but Mozilla Firefox and Google Chrome are always safe bets.
Download an Offline Copy of the Document
Instead of persistently trying to modify the document in the online version of Excel, you can download the offline copy of the file. Then, you can open it in the desktop Excel app and modify it there. Here is how to do it:
- Open the Excel file you’re trying to modify but that shows this MS Excel error.
- Select File, and then Save as.
- Select Download a Copy.
- Open the file on your desktop app as you usually do.
Whether you’re using a PC or a smartphone, you need to install an offline version of the Excel app to open the downloaded copy. Windows PC users can find the app in the Microsoft Store, Android users in the Google Play Store, and iOS users in the Apple Store.
Deselect, Wait, and then Try to Copy Again
Sometimes, all you have to do to fix the retrieving data error is to repeat your actions. This means you should try to cut and copy the data again. But first, make sure you deselect all the fields that you were trying to copy. Once everything is deselected, wait at least a few seconds before trying again. This gives the Excel program time to process the data and finish its synchronization.
Next, try selecting all the fields you want to copy and paste again. Use the Excel keyboard shortcuts to do so and optimize your workflow.
You can also try using an external application to paste the data. You might need to repeat these steps a few times to resolve the error.
These are all temporary solutions for fixing the “Retrieving Data Wait a Few Seconds and Try to Cut or Copy Again” error. There is no permanent solution due to the nature of the problem. However, all these fixes are quick and will let you continue your work undisturbed. So go ahead, try another web browser, or open the downloaded file in the desktop version of Excel.
But if you find another working solution, please let us know in the comment section below!