Solved

copy to sheet in different workbook

Posted on 2011-03-21
2
294 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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

733 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