Solved

copy to sheet in different workbook

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VBA Help 18 44
And OR formula 5 22
Excel error  #DIV/0! 7 18
Excel filter on tab not showing any entries? 5 22
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

778 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