Solved

copy to sheet in different workbook

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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 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.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

747 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

10 Experts available now in Live!

Get 1:1 Help Now