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?

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?

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?

.

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?

.

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?

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?