?
Solved

copy to sheet in different workbook

Posted on 2011-03-21
2
Medium Priority
?
297 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 2000 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

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.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
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 demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

752 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