Copying data between two instances of excel

Posted on 2013-05-21
Medium Priority
Last Modified: 2013-05-21
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.
Question by:Joseph Daly
LVL 23

Assisted Solution

NBVC earned 668 total points
ID: 39184858

Assisted Solution

agillanders earned 664 total points
ID: 39184865
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?


PS: As NB+VC points out this will not copy the formulas, only the results. But you state that NOTHING is getting copied!?!
LVL 35

Accepted Solution

[ fanpages ] earned 668 total points
ID: 39185733

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.


LVL 35

Author Closing Comment

by:Joseph Daly
ID: 39185744
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.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

Currently, there is an issue with being able to copy values from an external application to a dropdown list in Project Web Access (PWA).  The standard copy and paste methods don't seem to work properly. Here is a way to accomplish this task to s…
As a person who answers a lot of questions, I often see code that could be simplified, made easier to read, and perhaps most importantly made easier to maintain if the code was modified to use the Select Case statement. This article explains how to…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question