+ Reply to Thread
Results 1 to 17 of 17

Moving contents of cells

  1. #1
    Registered User
    Join Date
    02-08-2013
    Location
    Tulsa, OK
    MS-Off Ver
    Excel 2010
    Posts
    25

    Moving contents of cells

    About half of the time when I move the contents of a cell I get the message "The Clipboard cannot be emptied. Another program might be using the Clipboard" Can anyone recommend any fixes?

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Moving contents of cells

    I don't think I have ever received this message, but doing a quick Google search I came up with some possible fixes...

    The Clipboard cannot be emptied
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    02-08-2013
    Location
    Tulsa, OK
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Moving contents of cells

    Jeff
    Most of the comments in the link you provided mentioned a conflict with Skype, which has now been fixed. I don't have Skype so I read on. I found this interesting comment:

    I am a developer of an Excel Add-In product. Some of my customers complained vociferously about the "Cannot Empty Clipboard" box. My product does thousands of cell copies, so the appearance of this dialog thousands of times is quite a hindrance. In the case of my corporate customers, having Outlook open seemed to be what precipitated the problem.
    As a paid member of Microsoft Developer Network (MSDN), I opened a ticket on this issue. The engineers of the Visual Studio Office Developer Support Team reproduced the problem with the aid of a small application I sent them.
    They explained that Outlook needs to monitor the Windows clipboard. The Paste button or icon needs to be enabled when there is something to paste in a message, so Outlook must constantly monitor the clipboard. Then Excel asks too. Two applications asking for the clipboard contents result in the dumb "Cannot Empty Clipboard" dialog.
    The appearance of this dialog is clearly an architectural defect in Windows/Office clipboard management, and the MSDN team acknowledged this. They did not have a solution, and they promised to escalate this issue of MS Office development.
    In the case of my program, I have the workaround of programmatically disabling warnings when doing copy/paste.


    I closed Outlook and the problem disappeared. Apparently the problem is an Excel problem because Excel empties the clipboard after each use where the other programs don't.

    However, I find it disturbing that I have to disable my email in order to drag contents from one cell to another. I also find it more annoying that in the hear and a half since this post, Microsoft has not attempted to fix the problem.

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Moving contents of cells

    Hi Andy33,

    So you are saying this is semi-fixed. If you close Outlook it works, but if it is open you get the annoying message?

    Can you describe the exact steps you take when you get this message so I can attempt to duplicate?

  5. #5
    Registered User
    Join Date
    02-08-2013
    Location
    Tulsa, OK
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Moving contents of cells

    I grab a cell and drag the contents to another location. About 2/3 of the time I get the message I mentioned, and I have to acknowledge the dialog box to continue. But when I close Outlook, as I just experimented with, it doesn't happen at all. I guess "semi-fixed" is a good description because it appears that I will have to give up my email in order to work on my spreadsheets.

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Moving contents of cells

    Yes that is weird. I have Outlook open all day at work while working on spreadsheets and have never received the error.

    Could it be related to that one spreadsheet or is this something that periodically happens with no matter what spreadsheet?

    Sorry I don't know anymore to help...

  7. #7
    Registered User
    Join Date
    02-08-2013
    Location
    Tulsa, OK
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Moving contents of cells

    It happens on every spreadsheet. Thanks for your interest.

  8. #8
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Moving contents of cells

    It's not an Excel problem, as Excel deals with it properly, it's an 'Office' problem, one or more of the other programs (or the inter-program clipboard) does not deal with the clipboard properly, this is why it does work when you close the other file
    Best workaround I can see is do your drag and drop, then open out look and point it at right spot
    probably not what you wanted to hear, but I wouldn't even want to attempt to fix bugs in MS programs
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  9. #9
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Moving contents of cells

    does it happen with ctrl+x and ctrl+v instead of dragging?
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  10. #10
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Moving contents of cells

    ...just another thought. Is the workbook you are using for your copy an attachement in Outlook that you have clicked to open?

    If so try saving it somewhere else without first opening it, (still with Outlook open), then open the Excel file from wherever you have saved it.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  11. #11
    Registered User
    Join Date
    02-08-2013
    Location
    Tulsa, OK
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Moving contents of cells

    Joseph
    I do not get the message when I use the control keys or when I used copy and paste by right-clicking.

    Richard
    That was a good thought but, no, the current spreadsheet I created myself and has never been attached to an email.

    General comment
    I am new to this forum, and at this point I have more questions for people than answers. I am very appreciative for the sincere offer to help with this problem.

  12. #12
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Moving contents of cells

    which version of office 2010 is it-professional or other-and which version of windows? do you have any add-ins loaded in outlook?

  13. #13
    Registered User
    Join Date
    02-08-2013
    Location
    Tulsa, OK
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Moving contents of cells

    Joseph
    I have Microsoft Office Home and Student, version 14, 32 bit
    I also have Windows 7 64 bit.

    Yes, I do have an add-on in Outlook. Nuance PDF Converter.

  14. #14
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Moving contents of cells

    does it change anything if you disable that add-in?

  15. #15
    Registered User
    Join Date
    02-08-2013
    Location
    Tulsa, OK
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Moving contents of cells

    Joseph
    Maybe you're on to something. I disabled the Nuance add-in and also the One Note which I have no use for. I am still experiencing the problem. I checked my add-in list and was surprised to see the following active add-ins:

    Microsoft Outlook Hotmail Connector
    McAfee
    Windows Search Email Indexer
    Microsoft Exchange Unified Messaging
    Microsoft Office SharePoint Server Colleague Import
    Microsoft Outlook Mobile Service

    I know nothing about these and would be afraid to disable them.

  16. #16
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Moving contents of cells

    you can uncheck them all for testing and then enable them again afterwards

  17. #17
    Registered User
    Join Date
    02-08-2013
    Location
    Tulsa, OK
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Moving contents of cells

    I disabled every one of them. No change.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1