If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copying & Pasting
All of a sudden when I try to copy a sheet 1 from a workbook A to workbook B
sheet 1 it will not let me with out pulling up the office clip board and it never used to do this. I used to be able to just highlight, right click, and hit copy then go to the other workbook, right click, and hit paste. Also it will not copy the formulas over just the values. Any suggestions why? |
#2
|
|||
|
|||
Copying & Pasting
Sounds like you are running two instances of Excel with a workbook in each.
These will not communicate. Close one instance and open both workbooks in a single instance then do your copy/pasting. Gord Dibben MS Excel MVP On Thu, 19 Nov 2009 05:37:01 -0800, sjmonroe wrote: All of a sudden when I try to copy a sheet 1 from a workbook A to workbook B sheet 1 it will not let me with out pulling up the office clip board and it never used to do this. I used to be able to just highlight, right click, and hit copy then go to the other workbook, right click, and hit paste. Also it will not copy the formulas over just the values. Any suggestions why? |
#3
|
|||
|
|||
Copying & Pasting
I am having a similiar problem. My mouse functions for "right" click do not
function since Saturday. Did you get an anser to your question yet? Sue "sjmonroe" wrote: All of a sudden when I try to copy a sheet 1 from a workbook A to workbook B sheet 1 it will not let me with out pulling up the office clip board and it never used to do this. I used to be able to just highlight, right click, and hit copy then go to the other workbook, right click, and hit paste. Also it will not copy the formulas over just the values. Any suggestions why? |
#4
|
|||
|
|||
Copying & Pasting
That is not a similar problem.
No right-click menu when you right-click on a cell? Perhaps some code you ran disabled it. Alt + F11 to open VBE. ViewImmediate Window. Copy this into that window and hit ENTER key. Application.CommandBars("Cell").Enabled = True Alt + q to return to Excel............OK now? Gord Dibben MS Excel MVP On Thu, 19 Nov 2009 10:12:02 -0800, Sueb wrote: I am having a similiar problem. My mouse functions for "right" click do not function since Saturday. Did you get an anser to your question yet? Sue "sjmonroe" wrote: All of a sudden when I try to copy a sheet 1 from a workbook A to workbook B sheet 1 it will not let me with out pulling up the office clip board and it never used to do this. I used to be able to just highlight, right click, and hit copy then go to the other workbook, right click, and hit paste. Also it will not copy the formulas over just the values. Any suggestions why? |
#5
|
|||
|
|||
Copying & Pasting
How do I open both workbooks in a single instance? and why has this never
done this before? And if you open the clipboard then it will allow you to do it but the formulas and formatting will not be there. If you respond back please "dumb down" the answer. Thanks "Gord Dibben" wrote: Sounds like you are running two instances of Excel with a workbook in each. These will not communicate. Close one instance and open both workbooks in a single instance then do your copy/pasting. Gord Dibben MS Excel MVP On Thu, 19 Nov 2009 05:37:01 -0800, sjmonroe wrote: All of a sudden when I try to copy a sheet 1 from a workbook A to workbook B sheet 1 it will not let me with out pulling up the office clip board and it never used to do this. I used to be able to just highlight, right click, and hit copy then go to the other workbook, right click, and hit paste. Also it will not copy the formulas over just the values. Any suggestions why? . |
#6
|
|||
|
|||
Copying & Pasting
Save and Close out second workbook and click on the "X" to close Excel.
Do you still have the other workbook open in a session of Excel? If so, you had two instances of Excel running. FileOpen..........open workbook you just closed. Gord On Fri, 20 Nov 2009 10:57:03 -0800, sjmonroe wrote: How do I open both workbooks in a single instance? and why has this never done this before? And if you open the clipboard then it will allow you to do it but the formulas and formatting will not be there. If you respond back please "dumb down" the answer. Thanks "Gord Dibben" wrote: Sounds like you are running two instances of Excel with a workbook in each. These will not communicate. Close one instance and open both workbooks in a single instance then do your copy/pasting. Gord Dibben MS Excel MVP On Thu, 19 Nov 2009 05:37:01 -0800, sjmonroe wrote: All of a sudden when I try to copy a sheet 1 from a workbook A to workbook B sheet 1 it will not let me with out pulling up the office clip board and it never used to do this. I used to be able to just highlight, right click, and hit copy then go to the other workbook, right click, and hit paste. Also it will not copy the formulas over just the values. Any suggestions why? . |
Thread Tools | |
Display Modes | |
|
|