Solved

Copying data between two instances of excel

Posted on 2013-05-21
4
580 Views
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.
0
Comment
Question by:Joseph Daly
4 Comments
 
LVL 23

Assisted Solution

by:NBVC
NBVC earned 167 total points
ID: 39184858
0
 
LVL 8

Assisted Solution

by:agillanders
agillanders earned 166 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?

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
 
LVL 35

Accepted Solution

by:
[ fanpages ] earned 167 total points
ID: 39185733
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
 
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.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

867 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now