Solved

copy to sheet in different workbook

Posted on 2011-03-21
2
295 Views
Last Modified: 2012-05-11
I have a workbook with sheet1 which is active everyday at a place of business.  I want to modify this wkbk withsheet2 at another site and then when design is finished, copy from  old wkbk (sht1) to the new design in the new wkbk (sht2) which will than be used as the only workbook at the place of business.    When I try to open wkbk1, copy data, close that wkbk, open wkbk2, and paste special to Sht2, I get a "paste special" screen which reads "Inserts the contents of clipboard as a unicode text format" and I get no chance to paste "values only".   I suspect I need two instances of excel 2007 in order to past data into sht2 as "values only".  Please advise me on how to do this or what other method is available.

Thanks for you kind attention to this question!

Is there a spellcheck available in this "body" box?
0
Comment
Question by:1r3o2n8
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 23

Accepted Solution

by:
redrumkev earned 500 total points
ID: 35183330
1r3o2n8,

How are you doing?

If you open the task manager when this situation occurs, you should see two instances of Excel running. This is why you can't copy special, because Excel will not allow you to copy/paste special from one instance to another.

Try opening the first workbook, then go to the office button, open -> navigate and select the other workbook, to see if they open in the same instance, thus allowing for the copy/paste special operation.

Also, under Options -> Office button -> Excel Options (bottom right) -> Advanced (Left pane) -> scroll down to "General" - Is Ignore other applications that use Dynamic Data Exchange checked? If so, uncheck it, close all instances of Excel and try opening again.

Hope this helps,
Kevin
0
 

Author Closing Comment

by:1r3o2n8
ID: 35184486
It worked!  Thank you very much for the quick response.
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

690 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