A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Thanks for your feedback AKMC 117. I'm sorry it didn't work for you. Did you open Excel before or after Word?
BTW I'm running Office Home & Student 2013 on a new PC with Windows 8.1 OS.
I'm just your average MS Office user, so I have no idea why what I've done works (for me), but it works. I've been happily dragging and dropping cells all day in Excel without being annoyed by that pesky clipboard error dialog.
Sure, I will have to do the workaround every time I reboot, but at least it's better than closing other programs that may, or may not, be the cause of the issue.
Perhaps you could tell me what sort of "things" you did to get the error happening after you tried my workaround. Thanks,
The order made no difference. But it still comes back to what I was saying earlier; think about the mechanics behind this. Excel will spit that error when for whatever reason it thinks that another application has a lock on the clipboard. Copying a value into Word at the very start of your session is not going to affect what other applications (Skype, to cite the most commonly referred to application but there are plenty of others as this thread shows) do with the clipboard when someone has been working away for a few hours. At that point this kind of solution becomes less of a reliance on system engineering and more of a reliance on a combination of magic and wishful thinking. Given the (seemingly) random nature of the error as Ed alluded to in his post there will be times when it will stop happening for extended periods but it's just as likely to be coincidence as change. (Though in Ed's case it may be, may be, the upgrade to Windows 10 if Microsoft has made some changes to the way the Clipboard is accessed.)
I didn't specify the "things" because most of the people reading this thread would not be able to replicate them. The most common (not only, but most common) time that I encounter the error message at this particular moment (for as I said, apparent randomness is one of the features of this "feature") is when I use a third party add-in (which most people will never have heard off or be able to afford the licence fees for) which connects to an external data source and brings down data from that source into Excel. There will be times when I won't see it for weeks (more precisely I won't see it from that add-in, though I still periodically see it in regular Excel copy and paste operations for no apparent reason) but at the moment I don't have to do it too many times before I'll get it.
And no, the problem isn't with the add-in because:
(a) It's an Excel dialog, as at least two of us have been saying since the day dot Excel needs to be fixed; and
(b) It still happens seemingly randomly with other Excel actions.