| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special in Excel 2003
Hi Guys,
- I've created 2 blank Excel documents(book1, and book2) - I entered aa,bb,cc in A1,A2,A3 - Copy A1 to A3 and tried to paste it into B1 using paste spacial - paste special menu comes up and I can select values now - If I Copy A1 to A3 from book1 and try to paste into book2 using paste special - paste special menu (but this time it is different) opens up and it does not have a normal paste, values, formats, all, etc. - In this case, paste special menu has picture, bitmap, html, etc. Can you tell me how can I paste special into book2 and see the normal paste special menu which I see in book1? (paste by values) Is this an OS related setting? Someone has suggested to "uncheck" the in memory checkbox in Excel. Any Ideas? Thanks, f_r_e_d |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Special in Excel 2003
The difference is if the second workbook is opened within the same instance
of Excel or a separate instance. If the workbooks are in the same instance, you will see the normal Paste Special options you're looking for. If the workbooks are each in their own separate instance of Excel, then you see the other menu. In the later instance, if you just want to Paste Values, you should be able to select "Text" and get your desired results. HTH Elkar "f_r_e_d" wrote: Hi Guys, - I've created 2 blank Excel documents(book1, and book2) - I entered aa,bb,cc in A1,A2,A3 - Copy A1 to A3 and tried to paste it into B1 using paste spacial - paste special menu comes up and I can select values now - If I Copy A1 to A3 from book1 and try to paste into book2 using paste special - paste special menu (but this time it is different) opens up and it does not have a normal paste, values, formats, all, etc. - In this case, paste special menu has picture, bitmap, html, etc. Can you tell me how can I paste special into book2 and see the normal paste special menu which I see in book1? (paste by values) Is this an OS related setting? Someone has suggested to "uncheck" the in memory checkbox in Excel. Any Ideas? Thanks, f_r_e_d |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Special in Excel 2003
Thanks Elkar,
Can you tell me how my workbooks can be in the same instance? What should I do to make them to be in the same instance? Thanks, f_r_e_d "Elkar" wrote: The difference is if the second workbook is opened within the same instance of Excel or a separate instance. If the workbooks are in the same instance, you will see the normal Paste Special options you're looking for. If the workbooks are each in their own separate instance of Excel, then you see the other menu. In the later instance, if you just want to Paste Values, you should be able to select "Text" and get your desired results. HTH Elkar "f_r_e_d" wrote: Hi Guys, - I've created 2 blank Excel documents(book1, and book2) - I entered aa,bb,cc in A1,A2,A3 - Copy A1 to A3 and tried to paste it into B1 using paste spacial - paste special menu comes up and I can select values now - If I Copy A1 to A3 from book1 and try to paste into book2 using paste special - paste special menu (but this time it is different) opens up and it does not have a normal paste, values, formats, all, etc. - In this case, paste special menu has picture, bitmap, html, etc. Can you tell me how can I paste special into book2 and see the normal paste special menu which I see in book1? (paste by values) Is this an OS related setting? Someone has suggested to "uncheck" the in memory checkbox in Excel. Any Ideas? Thanks, f_r_e_d |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Special in Excel 2003
Close every instance of excel
Open the first workbook in excel then use File|Open to open the second. f_r_e_d wrote: Thanks Elkar, Can you tell me how my workbooks can be in the same instance? What should I do to make them to be in the same instance? Thanks, f_r_e_d "Elkar" wrote: The difference is if the second workbook is opened within the same instance of Excel or a separate instance. If the workbooks are in the same instance, you will see the normal Paste Special options you're looking for. If the workbooks are each in their own separate instance of Excel, then you see the other menu. In the later instance, if you just want to Paste Values, you should be able to select "Text" and get your desired results. HTH Elkar "f_r_e_d" wrote: Hi Guys, - I've created 2 blank Excel documents(book1, and book2) - I entered aa,bb,cc in A1,A2,A3 - Copy A1 to A3 and tried to paste it into B1 using paste spacial - paste special menu comes up and I can select values now - If I Copy A1 to A3 from book1 and try to paste into book2 using paste special - paste special menu (but this time it is different) opens up and it does not have a normal paste, values, formats, all, etc. - In this case, paste special menu has picture, bitmap, html, etc. Can you tell me how can I paste special into book2 and see the normal paste special menu which I see in book1? (paste by values) Is this an OS related setting? Someone has suggested to "uncheck" the in memory checkbox in Excel. Any Ideas? Thanks, f_r_e_d -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Special in Excel 2003
Try the usual fix for this.
ToolsOptionsGeneral Uncheck "Ignore Other Applications" If no joy with that................ Close Excel first and On the Windows Taskbar 1) StartRun "excel.exe /unregserver"(no quotes)OK. 2) 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 Dibben MS Excel MVP On Thu, 24 Jul 2008 12:16:02 -0700, f_r_e_d wrote: Thanks Elkar, Can you tell me how my workbooks can be in the same instance? What should I do to make them to be in the same instance? Thanks, f_r_e_d "Elkar" wrote: The difference is if the second workbook is opened within the same instance of Excel or a separate instance. If the workbooks are in the same instance, you will see the normal Paste Special options you're looking for. If the workbooks are each in their own separate instance of Excel, then you see the other menu. In the later instance, if you just want to Paste Values, you should be able to select "Text" and get your desired results. HTH Elkar "f_r_e_d" wrote: Hi Guys, - I've created 2 blank Excel documents(book1, and book2) - I entered aa,bb,cc in A1,A2,A3 - Copy A1 to A3 and tried to paste it into B1 using paste spacial - paste special menu comes up and I can select values now - If I Copy A1 to A3 from book1 and try to paste into book2 using paste special - paste special menu (but this time it is different) opens up and it does not have a normal paste, values, formats, all, etc. - In this case, paste special menu has picture, bitmap, html, etc. Can you tell me how can I paste special into book2 and see the normal paste special menu which I see in book1? (paste by values) Is this an OS related setting? Someone has suggested to "uncheck" the in memory checkbox in Excel. Any Ideas? Thanks, f_r_e_d |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Special in Excel 2003
Sounds like you have each workbook open in separate instances of Excel.
Close one instance and open both workbooks in a single instance. Gord Dibben MS Excel MVP On Thu, 24 Jul 2008 11:05:04 -0700, f_r_e_d wrote: Hi Guys, - I've created 2 blank Excel documents(book1, and book2) - I entered aa,bb,cc in A1,A2,A3 - Copy A1 to A3 and tried to paste it into B1 using paste spacial - paste special menu comes up and I can select values now - If I Copy A1 to A3 from book1 and try to paste into book2 using paste special - paste special menu (but this time it is different) opens up and it does not have a normal paste, values, formats, all, etc. - In this case, paste special menu has picture, bitmap, html, etc. Can you tell me how can I paste special into book2 and see the normal paste special menu which I see in book1? (paste by values) Is this an OS related setting? Someone has suggested to "uncheck" the in memory checkbox in Excel. Any Ideas? Thanks, f_r_e_d |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Special in Excel 2003
Thanks All, yes it seems it is working this way.
Now I have to modify my vba code to open each document from within each other. Good. Thanks, f_r_e_d "Gord Dibben" wrote: Sounds like you have each workbook open in separate instances of Excel. Close one instance and open both workbooks in a single instance. Gord Dibben MS Excel MVP On Thu, 24 Jul 2008 11:05:04 -0700, f_r_e_d wrote: Hi Guys, - I've created 2 blank Excel documents(book1, and book2) - I entered aa,bb,cc in A1,A2,A3 - Copy A1 to A3 and tried to paste it into B1 using paste spacial - paste special menu comes up and I can select values now - If I Copy A1 to A3 from book1 and try to paste into book2 using paste special - paste special menu (but this time it is different) opens up and it does not have a normal paste, values, formats, all, etc. - In this case, paste special menu has picture, bitmap, html, etc. Can you tell me how can I paste special into book2 and see the normal paste special menu which I see in book1? (paste by values) Is this an OS related setting? Someone has suggested to "uncheck" the in memory checkbox in Excel. Any Ideas? Thanks, f_r_e_d |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003/2007 paste special values shows bizarre results | Excel Worksheet Functions | |||
| Paste Special Help (Excel 2003) | Excel Discussion (Misc queries) | |||
| Excel 2003 -- Copying a formula to Paste Special into column cell | Excel Discussion (Misc queries) | |||
| In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
| Excel 2003 - paste special option | Excel Worksheet Functions | |||
Hybrid Mode
