Copying data between two instances of excel

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.
LVL 35
Joseph DalyAsked:
Who is Participating?
 
[ fanpages ]Connect With a Mentor IT Services ConsultantCommented:
Hi,

This issue may be difficult to reproduce as it may be linked to the actual display drivers installed within the operating system used within your organisation.

As an alternative approach to a standard "copy'n'paste", I would simply create a new workbook within the source session (Microsoft Excel instance), & copy the required content from the first workbook to that, then save/close the newly created workbook.

I would then open this new workbook in the other (destination) session & copy the content from there into the required workbook prior to closing the intermediary workbook.

BFN,

fp.
0
 
agillandersConnect With a Mentor Commented:
This is odd - and I can't repropduce it here.  I can copy/paste between Excel and other applications (including other instances of Excel) at will. Is there something specific you are not telling us about what is being clpied etc?

Remember, copy stores data into the Windows clipboard which has absolutely nothing to do with Excel. It stores the raw data and some metadata that basically describes the format the data is in. When you paste (into ANY application) the data is coming from the clipboard...not from Excel.

I take it the paste works fine in the original instance of Excel?

Alistair

PS: As NB+VC points out this will not copy the formulas, only the results. But you state that NOTHING is getting copied!?!
0
 
Joseph DalyAuthor Commented:
The issue ended up being a corrupted file. The thing that tipped me off is when i looked at the conditional formatting associated with the file it literally had hundreds of the same format visible.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.