| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can not copy a sheet to another book
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can not copy a sheet to another book
I would suggest opening your files using EXCEL.
-- Don Guillett Microsoft MVP Excel SalesAid Software "dveer" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can not copy a sheet to another book
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 "dveer" wrote in message ... 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? . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can not copy a sheet to another book
One usual fix for this is in Excel
ToolsOptionsGeneral and uncheck "ignore other applications" Gord Dibben MS Excel MVP On Fri, 23 Apr 2010 07:26:01 -0700, dveer 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 "dveer" wrote in message ... 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? . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can not copy a sheet to another book
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 ToolsOptionsGeneral and uncheck "ignore other applications" Gord Dibben MS Excel MVP On Fri, 23 Apr 2010 07:26:01 -0700, dveer 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 "dveer" wrote in message ... 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? . . |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can not copy a sheet to another book
I would suggest you re-register Excel
Close Excel first and On the Windows Taskbar StartRun "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 StartRun "C:\yourpath\excel.exe" /regserver(quotes required)OK Gord On Mon, 26 Apr 2010 01:19:02 -0700, dveer 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 ToolsOptionsGeneral and uncheck "ignore other applications" Gord Dibben MS Excel MVP On Fri, 23 Apr 2010 07:26:01 -0700, dveer 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 "dveer" wrote in message ... 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? . . |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can not copy a sheet to another book
Thanks Gord, this solved the problem!
"Gord Dibben" wrote: I would suggest you re-register Excel Close Excel first and On the Windows Taskbar StartRun "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 StartRun "C:\yourpath\excel.exe" /regserver(quotes required)OK Gord On Mon, 26 Apr 2010 01:19:02 -0700, dveer 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 ToolsOptionsGeneral and uncheck "ignore other applications" Gord Dibben MS Excel MVP On Fri, 23 Apr 2010 07:26:01 -0700, dveer 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 "dveer" wrote in message ... 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? . . . |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can not copy a sheet to another book
Good to hear.
Thanks for the feedback On Wed, 28 Apr 2010 00:53:01 -0700, dveer 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 StartRun "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 StartRun "C:\yourpath\excel.exe" /regserver(quotes required)OK Gord On Mon, 26 Apr 2010 01:19:02 -0700, dveer 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 ToolsOptionsGeneral and uncheck "ignore other applications" Gord Dibben MS Excel MVP On Fri, 23 Apr 2010 07:26:01 -0700, dveer 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 "dveer" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Too Few Rows to copy sheet to another book | Excel Worksheet Functions | |||
| copy worksheets to new book without linking to original book | Excel Discussion (Misc queries) | |||
| Copy a sheet to a new book unsuccessful | Excel Discussion (Misc queries) | |||
| copy the same raws of all sheets from about a 100 file to a new sheet of a book and save the file | Setting up and Configuration of Excel | |||
| date values change when I copy an excel sheet to a new book | Excel Discussion (Misc queries) | |||
Linear Mode
