I have a user with dual monitors. He frequently opens up two instances of excel so that he can drag one window to one screen and have the other on his second screen.
Today we came across a strange issue where he is unable to copy and paste between the worksheets in the seperate instances of excel. All that appears when selecting paste is a blank box the size of the copied area.
I have confirmed that this issue is present on a seperate machine as well so it looks like this might be an issue within excel itself.
Do you experts know of any way to copy and paste between instances or allow a single instace of excel to be able to move worksheets onto dual monitores.