如果您是 9-5 岁的白领专业人士,您很有可能每天多次打开Microsoft的几个Office应用程序之一;甚至可能在其中一个上开始和结束你的日子。在所有Office应用程序中,Excel获得了最多的操作,这是理所当然的。虽然互联网上充斥着电子表格程序,但没有什么能与Excel相比。为了进一步主导市场,微软(Microsoft)还拥有其三个最常用程序(Word、Excel和Powerpoint)的网络版本和移动应用程序,允许远程访问文件、实时共同创作、自动保存等。
然而,轻量级网络版本缺乏许多高级功能,因此,用户经常回到桌面应用程序。将数据从Excel Web应用程序粘贴到另一个应用程序甚至Excel 桌面(Excel desktop)客户端时,用户似乎遇到了错误,显示为“正在检索数据(Retrieving Data)” 。等待几秒钟,然后尝试再次剪切或复制'。乍一看, Excel(Excel)似乎只是在处理粘贴的信息,数据很快就会出现,错误消息中的“(error message)正在检索(Retrieving)数据”也意味着相同。虽然,等待对您没有好处,并且单元格将继续显示错误消息(error message)而不是数据。
从Excel 网页(Excel web)到Excel 桌面(Excel desktop)应用程序的上述复制粘贴错误多年来一直困扰着用户,但微软(Microsoft)未能为其提供永久性修复。缺乏官方解决方案迫使用户找到解决错误的独特方法。以下是解决“检索数据(Retrieving Data)”问题的所有已知修复程序。等待几秒钟并尝试再次剪切或复制”错误。
修复检索数据(Fix Retrieving Data)。等待几秒钟,然后尝试(A Few Seconds And Try)在Excel 中(Excel)再次剪切或复制错误(Or Copy Again Error)
首先,如果您收到“检索数据(Retrieving Data)”,请不要担心。等待几秒钟并尝试再次剪切或复制”错误,因为这不是重大错误,只需几秒钟即可解决。如果您在Excel 文件(excel file)的在线版本完成同步之前尝试复制数据,则会出现错误。用户一直在使用的三个修复程序是取消选择并再次复制粘贴内容,下载电子表格的离线副本并在桌面Excel 应用程序(Excel application)中打开它,或者完全使用不同的第三方浏览器。
方法一:取消选择,等待……再次复制粘贴(Method 1: Deselect, Wait…Copy again and paste)
执行错误消息指示的操作很少能完成工作。虽然,此特定错误并非如此。Excel要求您等待几秒钟,然后再次复制数据,这正是您应该做的。
因此,继续取消选择所有内容,喝杯水,或滚动浏览您的Instagram 提要(Instagram feed),按Ctrl + C复制并使用Ctrl + V将其粘贴到所需的应用程序中。在真正成功复制数据之前,您可能需要重复几次。无论如何,这只是一个临时解决方案,请查看其他两种方法以获得永久修复。
方法 2:下载 Excel 文件并在桌面应用程序中打开它(Method 2: Download the Excel file and open it in the Desktop app)
由于该错误仅在从Excel web复制或剪切数据时遇到,用户可以下载工作表的脱机副本并在Excel 桌面(Excel desktop)应用程序中打开它。从桌面客户端(desktop client)复制粘贴数据应该没有问题。
1.在Excel Web应用程序中打开您在复制数据时遇到问题的Excel 文件(Excel file)。
2. 单击左上角的文件。(File )
3. 单击另存为(Save As),然后从随后的选项中选择下载副本(Download a Copy)。
现在在 Excel 桌面客户端中打开下载的文件并从那里复制粘贴数据。(Excel desktop client and copy-paste data)如果您没有桌面程序(desktop program),您也可以使用Android和iOS上提供的移动应用程序。
方法三:换个浏览器试试(Method 3: Try a different browser)
在Internet Explorer 或 Microsoft Edge(Internet Explorer or Microsoft Edge)上使用Excel Web时,通常会遇到“正在检索数据...”错误。因此,用户可以通过使用不同的网络浏览器(web browser)来解决这个问题。该错误在Google Chrome(Google Chrome)和Mozilla Firefox中不太常见,因此您可以尝试使用其中之一。
推荐的:(Recommended:)
- 如何在Excel 中锁定(Excel)或解锁单元格(Or Unlock Cells)?
- 如何在Excel中交换(Excel)列或行(Columns or Rows)
- 如何在 Outlook 中撤回电子邮件?
- Discord文本格式(Discord Text Formatting)综合(Comprehensive Guide)指南
这就是本文的全部内容,我们希望本指南对您有所帮助,并且您能够修复检索数据。在 Excel 中等待几秒钟错误(fix Retrieving Data. Wait A Few Seconds error in Excel)。遵循上述指南后,您必须成功地将数据从Excel复制到所需位置。
Fix Retrieving Data. Wait A Few Seconds And Try To Cut Or Copy Again Error In Excel
If you are a 9-5, white-cоllar professіonal, chances are, you open one of Microsoft’s several Office applications multiple timеѕ a day; probably even start and end your dаys on one of them. Out of all Office applications, Exсel gets the most action, and rightfully so. Whіle the internet is flooded with spreadsheet programs, nothing compares to Excel. To further dominate the market, Microsоft also has web verѕions and mobile apрlications of its three most used programs (Word, Excel, and Powerpoint) allowing remote access to files, real-time сo-authoring, autosaving, etc.
The lightweight web-versions however lack a number of advanced features and therefore, users often revert back to the desktop applications. When pasting data from the Excel web app to another application or even the Excel desktop client, users seem to be encountering an error that reads ‘Retrieving Data. Wait a few seconds and try to cut or copy again’. At first glance, it may seem like Excel is simply processing the pasted information and the data will appear soon, the ‘Retrieving data’ in the error message also implies the same. Although, waiting will do you no good and the cell will continue displaying the error message instead of the data.
The said copy-pasting error from Excel web to Excel desktop application has been annoying users for many years, Microsoft has however failed to provide a permanent fix for it. A lack of an official solution has forced the users to find their own unique ways around the error. Below are all the fixes known to resolve the ‘Retrieving Data. Wait a Few Seconds and Try to Cut or Copy Again’ error.
Fix Retrieving Data. Wait A Few Seconds And Try To Cut Or Copy Again Error In Excel
Firstly, do not worry if you get the ‘Retrieving Data. Wait a Few Seconds and Try to Cut or Copy Again’ error, as this is not a major error and will take you only a few seconds to solve. The error results if you attempt to copy data before the online version of the excel file has finished syncing. The three fixes that users have been employing are deselecting and copy-pasting the content again, downloading an offline copy of the spreadsheet and opening it in the desktop Excel application, or using a different third-party browser altogether.
Method 1: Deselect, Wait…Copy again and paste
Performing the actions that error messages instruct rarely get the job done. Although, that is not the case with this particular error. Excel asks you to wait for a few seconds and then copy the data again, and that is exactly what you should do.
So, go ahead and deselect everything, have a glass of water, or scroll through your Instagram feed, press Ctrl + C to copy and paste it using Ctrl + V in the desired application. You may need to repeat this a couple of times before you are actually successful in copying the data. Anyway, this is just a temporary solution, check out the other two methods for a permanent fix.
Method 2: Download the Excel file and open it in the Desktop app
Since the error is only encountered when copying or cutting data from Excel web, users can download an offline copy of the sheet and open it in the Excel desktop app. You should face no trouble in copy-pasting data from the desktop client.
1. Open the Excel file you are having trouble copying data from in the Excel web app.
2. Click on File present at the top-left.
3. Click on Save As and from the options that follow, select Download a Copy.
Now open the downloaded file in Excel desktop client and copy-paste data from there. If you do not have the desktop program, you can also use the mobile applications available on Android and iOS.
Method 3: Try a different browser
The ‘Retrieving Data…’ error is usually encountered when using Excel web on either Internet Explorer or Microsoft Edge. Users have therefore been able to get around the issue by using a different web browser. The error is less prevalent in Google Chrome and Mozilla Firefox so you can try using one of them.
Recommended:
That’s all for this article, we hope this guide was helpful and you were able to fix Retrieving Data. Wait A Few Seconds error in Excel. After following the above guide, you must be successful in copying data from Excel to your desired location.