We could not copy the content to the Clipboard, it is in use by another application. You can still paste your content within this workbook but it will not be available in other applications.

Anonymous
2022-05-18T13:29:01+00:00

Win 10 version 21H2 Build 19044.1706

Excel 2016 Version 2204 Build 15128.20224

This problem occurs randomly and with only a few cells being copied. The spreadsheet locks up and the only way out is Save>Close and open the book again. Sometimes that doesn't work and I have to close Excel completely.

Sometimes the top ribbon completely greys out and I can't do anything.

This is becoming a significant problem.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

111 answers

Sort by: Most helpful
  1. Anonymous
    2023-03-03T13:55:13+00:00

    why don't we just diable copy and paste? that will do the trick as well.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2023-03-03T09:11:04+00:00

    That did the trick.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2023-02-08T04:10:32+00:00

    I posted an elaborate workaround that has been working for me on December 7 on this thread.

    The potential problem is that Excel 365 memory cache conflicts with the Windows memory cache. In my case Win 11.

    I use several combination of RAM clearing regularly throughout the session.

    First, disingage Autosave. I manually and constantly back up my file every three or four minutes. I found that if I have it on autosave, it uses excess memory and slows down Excel performance. Also, the synchronization between the Cloud and the Windows desktop system run amok in its coordination. Remember, you are really not working in real-time on the desktop. Clouds apps only give you a limited parameter since they are conservative virtual machines assigned to your account. Cloud apps are an inconvenience compared to actual apps running on the desktop itself, moreover, it is a convenient income-making/cost-saving program for the company. I'm not sure why people like to put up with this delivery model. It is what it is.

    Second, if I simply notice even a slight lag or glitch in the session, I clear all memory data from RAM. This should be done regularly regardless during the session.

    Procedure:

    • Clear (Clear All) the Clipboard located on the Excel ribbon.
    • Save file.
    • Clear the RAM through my Advance System Care (ASC) third-party app. I keep its RAM module floating on my desktop to determine how much RAM the system is using at a time. If it exceeds 60%, I clear it along with the other clearing procedures I have listed here. There may be other third party apps that perform a similar RAM clearing function other than using ASC.
    • I also doubledown by clicking on my Clear Clipboard icon shortcut I created using Windows cmd function, i.e. cmd: /c echo.|clip. This function can be entered in the Windows Run prompt. However you are better off creating a shortcut using %windir%\System32\cmd.exe /c “echo off | clip." Just Right-click on Desktop and click on New and then chooseShortcut from the context menu. In the "What item would you like to create a shortcut for?" section, copy and paste the cmd line. Click Next, give it a filename, then click Finish. This beats having to manually enter into cmd mode to clear memory regularly.
    • Once the RAM value drops to the average percentage of your Windows sessions (mine amounts to 45% RAM average use), I continue working.

    This workaround becomes habitual once you start doing it. This procedure is the only one I have found to work consistently. I still get rare, occassional hiccups, but at least it prevents freezing Excel.

    One more thing... close apps you are not using and Browser tabs not in use to avoid the swell-up of Windows RAM in the background.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments
  4. Anonymous
    2022-10-22T23:09:02+00:00

    I'm not even trying to use the clipboard and it's doing this. It's a major PITA.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments
  5. Anonymous
    2022-08-30T00:44:49+00:00

    Mine has always been unchecked.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments