Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Excel Instances & Paste Special
Currently, when I open multiple spreadsheets, they open in different
instances of excel. As a result (i believe), I cannot paste special values ( in the way they would if they were in the same instance). I have tried checking and unchecking "ignore other applications", "windows in taskbar". I use the transpose, format, etc quite often. I recently had Excel 2003 and 2007 installed on the same computer. This issue arose when i removed 2007. Since then, I have reinstalled 2003, but the problem still persists. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Excel Instances & Paste Special
You could always open a single instance of excel, then use File|Open to open the
other workbooks. Or you could try to fix windows/excel so that when you double click on an excel file, it won't open a second instance. Tools|Options|General|Ignore other applications (uncheck it) --- or --- Close Excel and Windows Start Button|Run excel /unregserver then Windows Start Button|Run excel /regserver The /unregserver & /regserver stuff resets some of the windows registry to excel's factory defaults. Maybe one of these will work for you. AFoyle wrote: Currently, when I open multiple spreadsheets, they open in different instances of excel. As a result (i believe), I cannot paste special values ( in the way they would if they were in the same instance). I have tried checking and unchecking "ignore other applications", "windows in taskbar". I use the transpose, format, etc quite often. I recently had Excel 2003 and 2007 installed on the same computer. This issue arose when i removed 2007. Since then, I have reinstalled 2003, but the problem still persists. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Excel Instances & Paste Special
I have tried all the suggestions, but the files are still opening in separate
instances with the exception of File|open. I would really like to try and restore excel so my spreadsheets open in single instances once again. I simply do not understand why it started to behave this way! Are there any other options that are open to me that i can try? "Dave Peterson" wrote: You could always open a single instance of excel, then use File|Open to open the other workbooks. Or you could try to fix windows/excel so that when you double click on an excel file, it won't open a second instance. Tools|Options|General|Ignore other applications (uncheck it) --- or --- Close Excel and Windows Start Button|Run excel /unregserver then Windows Start Button|Run excel /regserver The /unregserver & /regserver stuff resets some of the windows registry to excel's factory defaults. Maybe one of these will work for you. AFoyle wrote: Currently, when I open multiple spreadsheets, they open in different instances of excel. As a result (i believe), I cannot paste special values ( in the way they would if they were in the same instance). I have tried checking and unchecking "ignore other applications", "windows in taskbar". I use the transpose, format, etc quite often. I recently had Excel 2003 and 2007 installed on the same computer. This issue arose when i removed 2007. Since then, I have reinstalled 2003, but the problem still persists. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Excel Instances & Paste Special
Don't know why the regserver steps won't work for you.
When you run the regserver command do you get any message that configuration is starting? Any error message? If yes and no there is another option available. Go to StartSettingsControl PanelFolder OptionsFile Types If using WinXP OS you would scroll down to .XLS then "Advanced"OpenEdit. In Command line the path should be similar to this.... "C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e You must have the double quotes and the <space/e prevents a new blank book from opening. Below have "use DDE" checked and this in the DDE message box....[open("%1")] Application should read "Excel"(no quotes) Gord Dibben MS Excel MVP On Wed, 20 Feb 2008 15:02:01 -0800, AFoyle wrote: I have tried all the suggestions, but the files are still opening in separate instances with the exception of File|open. I would really like to try and restore excel so my spreadsheets open in single instances once again. I simply do not understand why it started to behave this way! Are there any other options that are open to me that i can try? "Dave Peterson" wrote: You could always open a single instance of excel, then use File|Open to open the other workbooks. Or you could try to fix windows/excel so that when you double click on an excel file, it won't open a second instance. Tools|Options|General|Ignore other applications (uncheck it) --- or --- Close Excel and Windows Start Button|Run excel /unregserver then Windows Start Button|Run excel /regserver The /unregserver & /regserver stuff resets some of the windows registry to excel's factory defaults. Maybe one of these will work for you. AFoyle wrote: Currently, when I open multiple spreadsheets, they open in different instances of excel. As a result (i believe), I cannot paste special values ( in the way they would if they were in the same instance). I have tried checking and unchecking "ignore other applications", "windows in taskbar". I use the transpose, format, etc quite often. I recently had Excel 2003 and 2007 installed on the same computer. This issue arose when i removed 2007. Since then, I have reinstalled 2003, but the problem still persists. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Excel Instances & Paste Special
One of these techniques has worked for lots and lots of people (but not all for
some reason). Before you go to the lengths that Gord describes in his post, you may want to try both of those suggestions once more. Maybe you made a mistake the first time???? AFoyle wrote: I have tried all the suggestions, but the files are still opening in separate instances with the exception of File|open. I would really like to try and restore excel so my spreadsheets open in single instances once again. I simply do not understand why it started to behave this way! Are there any other options that are open to me that i can try? "Dave Peterson" wrote: You could always open a single instance of excel, then use File|Open to open the other workbooks. Or you could try to fix windows/excel so that when you double click on an excel file, it won't open a second instance. Tools|Options|General|Ignore other applications (uncheck it) --- or --- Close Excel and Windows Start Button|Run excel /unregserver then Windows Start Button|Run excel /regserver The /unregserver & /regserver stuff resets some of the windows registry to excel's factory defaults. Maybe one of these will work for you. AFoyle wrote: Currently, when I open multiple spreadsheets, they open in different instances of excel. As a result (i believe), I cannot paste special values ( in the way they would if they were in the same instance). I have tried checking and unchecking "ignore other applications", "windows in taskbar". I use the transpose, format, etc quite often. I recently had Excel 2003 and 2007 installed on the same computer. This issue arose when i removed 2007. Since then, I have reinstalled 2003, but the problem still persists. -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Excel Instances & Paste Special
On Feb 21, 7:02*am, AFoyle wrote:
I have tried all the suggestions, but the files are still opening in separate instances with the exception of File|open. I would really like to try andrestoreexcel so my spreadsheets open in single instances once again. * I simply do not understand why it started to behave this way! *Are there any other options that are open to me that i can try? "Dave Peterson" wrote: You could always open a single instance of excel, then use File|Open to open the other workbooks. Or you could try to fix windows/excel so that when you double click on an excel file, it won't open a second instance. Tools|Options|General|Ignore other applications (uncheck it) --- or --- Close Excel and Windows Start Button|Run excel /unregserver then Windows Start Button|Run excel /regserver The /unregserver & /regserver stuff resets some of the windows registry to excel's factory defaults. Maybe one of these will work for you. AFoyle wrote: Currently, when I open multiple spreadsheets, they open in different instances of excel. *As a result (i believe), I cannot paste special values ( in the way they would if they were in the same instance). *I have tried checking and unchecking "ignore other applications", "windows in taskbar". I use the transpose, format, etc quite often. *I recently had Excel 2003 and 2007 installed on the same computer. This issue arose when i removed 2007. Since then, I have reinstalled 2003, but the problem still persists. -- Dave Peterson- Hide quoted text - - Show quoted text - Maybe you can try a popular Excel file recovery tool called Advanced Excel Repair to repair your Excel file. It is a powerful tool to repair corrupt or damaged Excel files. Detailed information about Advanced Excel Repair can be found at http://www.datanumen.com/aer/ And you can also download a free demo version at http://www.datanumen.com/aer/aer.exe Hope this will help. Alan |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Excel Instances & Paste Special
I don't think that this thread has anything to do with a corrupted workbook.
But it did give you a chance to advertise your program, huh? <<snipped |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
Paste and Paste Special command are not enabled in Excel | Excel Worksheet Functions | |||
MS Excel Paste SpecialPaste All | Excel Discussion (Misc queries) |