Sometimes on Microsoft Excel (Web), the find feature does not nothing. You type in the search text and click Find All then nothing happens. Put in a different search text and still nothing happens.
Refresh the page and suddenly everything works as expected.
Possibility of issue may be that I keep the page open for a maybe an hour or two. Machine was rebooted in the morning a few hours prior. This is not the first time facing this issue.
I completely dislike how Microsoft implemented its copy/paste feature on the web. It completely ruins how copy/paste for EVERYTHING else even its own operating system. I just want to simply copy/paste a data from one cell to something else. Anything except a directly copy/paste from cell to cell is always questionable on why it works or doesn't work (even cell to cell is questionable in my mind but seems to at least work most of the time).
Why?!?! It is the most tested and used feature.
I just want to a text inside of one cell to a text inside another cell... same sheet, same row. Simple? Of course, Microsoft does not want it to be! Worst is to cut it because the original data is GONE so what am I supposed to go back to if the paste doesn't work? Obviously, I have to undo but that also messes with the clipboard. How stressful it is just to copy/paste!
What could possibly be wrong? I HAVE ABSOLUTELY NOT IDEA! I just do it again and it will sometimes work and sometimes not. I just keep repeating until it works. No seeable changes to the steps. I even tested with other applications and they all copy/paste fine. So is it memory? Doesn't seem like it. I tried with the same browser and even the same tab. Is it the browser? Doesn't seem like it too. But for stupid's sake, I even rebooted and perform the same task first with no other applications open yet... and yet, not always!
WHY?!?!
While on this topic... why does inserting or delete a wrong clear my clipboard? Why does double-clicking into a cell SOMETIMES clear the clipboard? SOMETIMES? Why is it even SOMETIMES? I rather have the row insert where it is always cleared.
Oh is it just a temporary clipboard for web Excel? Nope, even if you do not copy/paste or copy from Excel (ie you had copied something from another browser, app, or even the app version of Excel)... it is completely gone.
Also, sometimes it'll appear to copy (where the border changes when you normally copy) then when you paste, it says the data is not available. Why does that happy? No clue. How to workaround? Repeat until it works. Sometimes it takes 10s of times until it works. I can even copy/paste in the middle with other apps and it will work perfectly fine. I can copy another row to change the border cell, go back to copy, and it still won't work. I can wait minutes, hours... and it will won't paste even though the message says to give it time. Perhaps Microsoft is a black hole and time works differently there because copy/paste works perfectly fine before, during, and after this issue. Seems to ONLY be the web version of Excel. It is also funny that there are more issues with pasting from web version to app version of Excel than everything else combined.
I think this is very border-line "Not recommending to others" deal-breaker. Especially if you have the manual task of copy/pasting menial tasks.
Even worse... I've been having this issue for over a year now. I even posted this here, Buggish: Microsoft Web Excel Copy/Paste (https://douglastclee.blogspot.com/2023/09/buggish-microsoft-web-excel-copypaste.html).
I totally hate Microsoft's copy/paste feature on its Excel web application. It does not comply with the traditional copy/paste feature.
Certain actions like clicking into a cell will clear the clipboard. Worse yet, some actions appear random. For example, I want to move a part of a text from one cell to another. I double-click, select the text I want, cut, and I see the text disappear. I then double-click in the cell I want to paste, and nothing pastes. Try pasting elsewhere like notepad, nothing... zippo.... nada.... zilch. Undo, and try again... and still the same result.
Because I am insane, I try a third time... and behold... it now pastes. What gives?!
This is definitely not the first time. I believe I have an older post complaining about this copy/paste. It is annoying enough that I may keep posting about it.
Both
=FILTER(A2:A1019,ISNUMBER(XMATCH(A2:A1019,B2:B1119,0)))
Only A
=FILTER(A2:A1019,ISNA(XMATCH(A2:A1019,B2:B1119,0)))
Only B
=FILTER(B2:B1119,ISNA(XMATCH(B2:B1119,A2:A1019,0)))
Any activity with a cell in the version of Microsoft excel keeps clearing the clipboard. I do a lot of cross-referencing with it and I constantly have to re-copy data.
Any activities like create insert new line, clicking inside a cell, escaping select cell(s), pretty much anything that has to do with a cell will force me to copy from origin again.
This is the global clipboard meaning even if the copied data is not for excel, it is cleared out.
This is quite annoying. This has been going on for a very, very long time. The straw that broke the camel's back was that the cell errored for some reason and I still lost my data.
Not life critical... but extremely frustrating to work around.
I use Microsoft Teams Web Excel. There is an obvious performance issue at 7500+ records with about 15 columns that are mostly populated.
This spreadsheet is an audit history of objects that I have promoted since last year. The largest column is the object path which typically would be file paths as they would include server and folder paths. The other columns are simple strings at most 50 characters or date-time fields.
The biggest problem is the copy/paste. I will oftentimes get the error:
Retrieving data. Wait a few seconds and try to cut or copy again.
Before, waiting will sometimes work but now waiting does not seem to work at all. I do not know if waiting will ever work but I've tried pasting a few hours later and I will still get this message.
Copy/pasting rows now take time. Inserting new rows take time. If I keep my browser open overnight, sometimes it takes a minute or two just for the page to allow me to click on something.
Do I know specifically that this is due to the number of records? No. I am only assuming because it seems to be a trend I see with Microsoft products. Also there is weak correlations between the number of records and frequency of issues or length of delay.
Rebooting sometimes helped before. Now, most little tricks to improve performance no longer work.
I split some old data to another sheet, and the performance almost seems immediately better. I moved about 2500 records out of the primary sheet. With around 5200 records, performance still has intermittent issues but much less frequent and faster but still noticeable.
| SQL Server Management Studio | v18.4 |
| Google Chrome | Version 83.0.4103.97 (Official Build) (64-bit) |
| Teams Excel (Web) | 16.0.13014.35904 |
Although the ability to update SharePoint lists from Office Excel 2007 is deprecated in favor of publishing and synchronizing lists using Office Access 2007, you can use the Excel 2007 SharePoint List Synchronizing Add-in to update SharePoint lists from Office Excel 2007. ~ (Reference-1 MSDN)
