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
<(E-Mail Removed)> 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.

View>Immediate 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 <(E-Mail Removed)>
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?

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
> <(E-Mail Removed)> 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.

File>Open..........open workbook you just closed.


Gord

On Fri, 20 Nov 2009 10:57:03 -0800, sjmonroe
<(E-Mail Removed)> 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
>> <(E-Mail Removed)> 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?
>>
>> .
>>