PC Review


Reply
Thread Tools Rate Thread

Can not copy a sheet to another book

 
 
dveer
Guest
Posts: n/a
 
      23rd Apr 2010
When I open 2 workbooks in 2 instances of Excel on my computer, I can not
copy a sheet from one book to the other. It is also not possible to tile the
2 files.
When I open both files in the same instance, it it possible to select the
other file in the dropdown list.
Since I usually open the files from Explorer, I would like to be able to
tile & copy when multiple files are opened.
What setting should I change?

 
Reply With Quote
 
 
 
 
Don Guillett
Guest
Posts: n/a
 
      23rd Apr 2010
I would suggest opening your files using EXCEL.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"dveer" <(E-Mail Removed)> wrote in message
news:B940BACF-8F0C-43E9-92CD-(E-Mail Removed)...
> When I open 2 workbooks in 2 instances of Excel on my computer, I can not
> copy a sheet from one book to the other. It is also not possible to tile
> the
> 2 files.
> When I open both files in the same instance, it it possible to select the
> other file in the dropdown list.
> Since I usually open the files from Explorer, I would like to be able to
> tile & copy when multiple files are opened.
> What setting should I change?
>


 
Reply With Quote
 
dveer
Guest
Posts: n/a
 
      23rd Apr 2010
I was hoping for some more advanced tips :-(
It works on most of the other computers in our office

"Don Guillett" wrote:

> I would suggest opening your files using EXCEL.
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> (E-Mail Removed)
> "dveer" <(E-Mail Removed)> wrote in message
> news:B940BACF-8F0C-43E9-92CD-(E-Mail Removed)...
> > When I open 2 workbooks in 2 instances of Excel on my computer, I can not
> > copy a sheet from one book to the other. It is also not possible to tile
> > the
> > 2 files.
> > When I open both files in the same instance, it it possible to select the
> > other file in the dropdown list.
> > Since I usually open the files from Explorer, I would like to be able to
> > tile & copy when multiple files are opened.
> > What setting should I change?
> >

>
> .
>

 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      24th Apr 2010
One usual fix for this is in Excel

Tools>Options>General and uncheck "ignore other applications"


Gord Dibben MS Excel MVP

On Fri, 23 Apr 2010 07:26:01 -0700, dveer <(E-Mail Removed)>
wrote:

>I was hoping for some more advanced tips :-(
>It works on most of the other computers in our office
>
>"Don Guillett" wrote:
>
>> I would suggest opening your files using EXCEL.
>>
>> --
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> (E-Mail Removed)
>> "dveer" <(E-Mail Removed)> wrote in message
>> news:B940BACF-8F0C-43E9-92CD-(E-Mail Removed)...
>> > When I open 2 workbooks in 2 instances of Excel on my computer, I can not
>> > copy a sheet from one book to the other. It is also not possible to tile
>> > the
>> > 2 files.
>> > When I open both files in the same instance, it it possible to select the
>> > other file in the dropdown list.
>> > Since I usually open the files from Explorer, I would like to be able to
>> > tile & copy when multiple files are opened.
>> > What setting should I change?
>> >

>>
>> .
>>


 
Reply With Quote
 
dveer
Guest
Posts: n/a
 
      26th Apr 2010
Unfortunately this also did not help, this box was already unchecked.
Any other ideas?

"Gord Dibben" wrote:

> One usual fix for this is in Excel
>
> Tools>Options>General and uncheck "ignore other applications"
>
>
> Gord Dibben MS Excel MVP
>
> On Fri, 23 Apr 2010 07:26:01 -0700, dveer <(E-Mail Removed)>
> wrote:
>
> >I was hoping for some more advanced tips :-(
> >It works on most of the other computers in our office
> >
> >"Don Guillett" wrote:
> >
> >> I would suggest opening your files using EXCEL.
> >>
> >> --
> >> Don Guillett
> >> Microsoft MVP Excel
> >> SalesAid Software
> >> (E-Mail Removed)
> >> "dveer" <(E-Mail Removed)> wrote in message
> >> news:B940BACF-8F0C-43E9-92CD-(E-Mail Removed)...
> >> > When I open 2 workbooks in 2 instances of Excel on my computer, I can not
> >> > copy a sheet from one book to the other. It is also not possible to tile
> >> > the
> >> > 2 files.
> >> > When I open both files in the same instance, it it possible to select the
> >> > other file in the dropdown list.
> >> > Since I usually open the files from Explorer, I would like to be able to
> >> > tile & copy when multiple files are opened.
> >> > What setting should I change?
> >> >
> >>
> >> .
> >>

>
> .
>

 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      26th Apr 2010
I would suggest you re-register Excel

Close Excel first and On the Windows Taskbar

Start>Run "excel.exe /regserver"(no quotes)>OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe.

In that case Start>Run "C:\yourpath\excel.exe" /regserver(quotes
required)>OK


Gord


On Mon, 26 Apr 2010 01:19:02 -0700, dveer <(E-Mail Removed)>
wrote:

>Unfortunately this also did not help, this box was already unchecked.
>Any other ideas?
>
>"Gord Dibben" wrote:
>
>> One usual fix for this is in Excel
>>
>> Tools>Options>General and uncheck "ignore other applications"
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Fri, 23 Apr 2010 07:26:01 -0700, dveer <(E-Mail Removed)>
>> wrote:
>>
>> >I was hoping for some more advanced tips :-(
>> >It works on most of the other computers in our office
>> >
>> >"Don Guillett" wrote:
>> >
>> >> I would suggest opening your files using EXCEL.
>> >>
>> >> --
>> >> Don Guillett
>> >> Microsoft MVP Excel
>> >> SalesAid Software
>> >> (E-Mail Removed)
>> >> "dveer" <(E-Mail Removed)> wrote in message
>> >> news:B940BACF-8F0C-43E9-92CD-(E-Mail Removed)...
>> >> > When I open 2 workbooks in 2 instances of Excel on my computer, I can not
>> >> > copy a sheet from one book to the other. It is also not possible to tile
>> >> > the
>> >> > 2 files.
>> >> > When I open both files in the same instance, it it possible to select the
>> >> > other file in the dropdown list.
>> >> > Since I usually open the files from Explorer, I would like to be able to
>> >> > tile & copy when multiple files are opened.
>> >> > What setting should I change?
>> >> >
>> >>
>> >> .
>> >>

>>
>> .
>>


 
Reply With Quote
 
dveer
Guest
Posts: n/a
 
      28th Apr 2010
Thanks Gord, this solved the problem!


"Gord Dibben" wrote:

> I would suggest you re-register Excel
>
> Close Excel first and On the Windows Taskbar
>
> Start>Run "excel.exe /regserver"(no quotes)>OK.
>
> See the space between exe and /regserver
>
> You might have to designate a full path to excel.exe.
>
> In that case Start>Run "C:\yourpath\excel.exe" /regserver(quotes
> required)>OK
>
>
> Gord
>
>
> On Mon, 26 Apr 2010 01:19:02 -0700, dveer <(E-Mail Removed)>
> wrote:
>
> >Unfortunately this also did not help, this box was already unchecked.
> >Any other ideas?
> >
> >"Gord Dibben" wrote:
> >
> >> One usual fix for this is in Excel
> >>
> >> Tools>Options>General and uncheck "ignore other applications"
> >>
> >>
> >> Gord Dibben MS Excel MVP
> >>
> >> On Fri, 23 Apr 2010 07:26:01 -0700, dveer <(E-Mail Removed)>
> >> wrote:
> >>
> >> >I was hoping for some more advanced tips :-(
> >> >It works on most of the other computers in our office
> >> >
> >> >"Don Guillett" wrote:
> >> >
> >> >> I would suggest opening your files using EXCEL.
> >> >>
> >> >> --
> >> >> Don Guillett
> >> >> Microsoft MVP Excel
> >> >> SalesAid Software
> >> >> (E-Mail Removed)
> >> >> "dveer" <(E-Mail Removed)> wrote in message
> >> >> news:B940BACF-8F0C-43E9-92CD-(E-Mail Removed)...
> >> >> > When I open 2 workbooks in 2 instances of Excel on my computer, I can not
> >> >> > copy a sheet from one book to the other. It is also not possible to tile
> >> >> > the
> >> >> > 2 files.
> >> >> > When I open both files in the same instance, it it possible to select the
> >> >> > other file in the dropdown list.
> >> >> > Since I usually open the files from Explorer, I would like to be able to
> >> >> > tile & copy when multiple files are opened.
> >> >> > What setting should I change?
> >> >> >
> >> >>
> >> >> .
> >> >>
> >>
> >> .
> >>

>
> .
>

 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      28th Apr 2010
Good to hear.

Thanks for the feedback

On Wed, 28 Apr 2010 00:53:01 -0700, dveer <(E-Mail Removed)>
wrote:

>Thanks Gord, this solved the problem!
>
>
>"Gord Dibben" wrote:
>
>> I would suggest you re-register Excel
>>
>> Close Excel first and On the Windows Taskbar
>>
>> Start>Run "excel.exe /regserver"(no quotes)>OK.
>>
>> See the space between exe and /regserver
>>
>> You might have to designate a full path to excel.exe.
>>
>> In that case Start>Run "C:\yourpath\excel.exe" /regserver(quotes
>> required)>OK
>>
>>
>> Gord
>>
>>
>> On Mon, 26 Apr 2010 01:19:02 -0700, dveer <(E-Mail Removed)>
>> wrote:
>>
>> >Unfortunately this also did not help, this box was already unchecked.
>> >Any other ideas?
>> >
>> >"Gord Dibben" wrote:
>> >
>> >> One usual fix for this is in Excel
>> >>
>> >> Tools>Options>General and uncheck "ignore other applications"
>> >>
>> >>
>> >> Gord Dibben MS Excel MVP
>> >>
>> >> On Fri, 23 Apr 2010 07:26:01 -0700, dveer <(E-Mail Removed)>
>> >> wrote:
>> >>
>> >> >I was hoping for some more advanced tips :-(
>> >> >It works on most of the other computers in our office
>> >> >
>> >> >"Don Guillett" wrote:
>> >> >
>> >> >> I would suggest opening your files using EXCEL.
>> >> >>
>> >> >> --
>> >> >> Don Guillett
>> >> >> Microsoft MVP Excel
>> >> >> SalesAid Software
>> >> >> (E-Mail Removed)
>> >> >> "dveer" <(E-Mail Removed)> wrote in message
>> >> >> news:B940BACF-8F0C-43E9-92CD-(E-Mail Removed)...
>> >> >> > When I open 2 workbooks in 2 instances of Excel on my computer, I can not
>> >> >> > copy a sheet from one book to the other. It is also not possible to tile
>> >> >> > the
>> >> >> > 2 files.
>> >> >> > When I open both files in the same instance, it it possible to select the
>> >> >> > other file in the dropdown list.
>> >> >> > Since I usually open the files from Explorer, I would like to be able to
>> >> >> > tile & copy when multiple files are opened.
>> >> >> > What setting should I change?
>> >> >> >
>> >> >>
>> >> >> .
>> >> >>
>> >>
>> >> .
>> >>

>>
>> .
>>


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Too Few Rows to copy sheet to another book snowboardbaltimore Microsoft Excel Worksheet Functions 2 19th Apr 2010 05:36 PM
Copy a sheet to a new book unsuccessful sunan Microsoft Excel Misc 3 23rd Jun 2008 12:52 PM
Chk sheet exits, copy all to another book. Karen53 Microsoft Excel Programming 7 23rd Apr 2008 09:25 PM
create new book and copy sheet into.. Kstalker Microsoft Excel Programming 8 3rd Jul 2005 11:14 PM
copy printarea from more than 3 sheet & save in new book. Shital Microsoft Excel Programming 1 4th Oct 2003 10:47 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:46 PM.