1
I am experiencing a very annoying bug in Excel 2016, and I would like to know how to fix/workaround it, and other information.
Note: in my company, we use Microsoft Excel 2016 (Version 1708, build 8431.2079) on Windows 10. I have used Excel on a daily basis for a few years, and I haven't experienced this bug in the previous versions.
Note 2: we also use Jedox for Excel add-in. It might cause a few bugs and is sadly unstable from time to time. Could be linked to the bug.
In short, the bug occurs when I want to copy/paste cells from one workbook to another — paste mode not relevant here. After copying the cells, I go to the other workbook to paste, but there is nothing to paste: the clipboard is empty, and there is no "paste as" option visible. As if I never copied anything.
The bug doesn't occur when copy/pasting within the same worksheet, or even between sheets in the same workbook.
I think I found the issue, or at least what creates the bug. It starts happening as soon as a file is closed. After that, it's impossible to copy/paste from a workbook to another.
I established a test protocol to reproduce the bug:
- Open Excel and create three new workbooks (A, B and C)
- Check that copy/paste works by writing data into each of them, and copy/pasting cells from workbook to workbook
- Close one of the workbooks
- Try to copy/paste cells between the remaining workbooks. If you have this bug as well, it shouldn't be possible.
It would be interesting to know if some of you can reproduce this bug as well. I'm not sure it is linked to Excel itself, or if this has something to do with the Jedox add-in I have installed (and which I cannot disable, sadly).
And, of course, I want to know: what is the remedy?
So far, two workarounds: 1) using the clipboard manager. 2) keeping workbooks opened... If you close one, you'll have to save your fils and relaunch Excel. – KZN – 2017-10-17T07:36:01.247
And another one: select the cells you want to copy, position your mouse over the border of the selection, drag it to the new workbook (you can use Alt+Tab to switch to another workbook while holding), and before releasing the cells, press control to make a copy (otherwise it will only move your data). Of course, this might not work properly if what you want to copy has formulas inside. – KZN – 2017-10-17T07:47:25.650