Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy paste special
Excel 2007 - when attempting to "copy - paste" both from within the same
worksheet and from other open worksheets the drop down menu in the clipboard does not give me the Paste special option as described in the Help topics (as was available in thye excel 2003) right clicking paste in the target area gives me the paste special option but when I click it it opens in a window that only allows the options of "unicode text" or "text". There is no menue of options as in 2003. Where is my copy special features? I have uninstalled and reinstalled Office 2007 with no avail. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy paste special
R-click on the destination and select Paste Special.
CGCPA wrote: Excel 2007 - when attempting to "copy - paste" both from within the same worksheet and from other open worksheets the drop down menu in the clipboard does not give me the Paste special option as described in the Help topics (as was available in thye excel 2003) right clicking paste in the target area gives me the paste special option but when I click it it opens in a window that only allows the options of "unicode text" or "text". There is no menue of options as in 2003. Where is my copy special features? I have uninstalled and reinstalled Office 2007 with no avail. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy paste special
It would appear that you art not copying a cell but only a portion.
Select and copy the cell. CGCPA wrote: Excel 2007 - when attempting to "copy - paste" both from within the same worksheet and from other open worksheets the drop down menu in the clipboard does not give me the Paste special option as described in the Help topics (as was available in thye excel 2003) right clicking paste in the target area gives me the paste special option but when I click it it opens in a window that only allows the options of "unicode text" or "text". There is no menue of options as in 2003. Where is my copy special features? I have uninstalled and reinstalled Office 2007 with no avail. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy paste special
Thanks for the reply Bob, yes I have correctly selected the cells and have
right clicked in the target area "destination" - I have gone to the clipboard hit copy from there then attempted to go to destination then "paste " from the clipboard. I've been doing this (complex spreadsheets) for 30 years and have tried all the options. I'm baffled to say the least. There is a conflic somewhere that is killing excel, no viruses, running MS sql 2005 application programs, Prevasive Database of Peachtree, Quickbooks, applications in Access, other acctg applications and etc . Your help is greatly appreciated "Bob I" wrote: R-click on the destination and select Paste Special. CGCPA wrote: Excel 2007 - when attempting to "copy - paste" both from within the same worksheet and from other open worksheets the drop down menu in the clipboard does not give me the Paste special option as described in the Help topics (as was available in thye excel 2003) right clicking paste in the target area gives me the paste special option but when I click it it opens in a window that only allows the options of "unicode text" or "text". There is no menue of options as in 2003. Where is my copy special features? I have uninstalled and reinstalled Office 2007 with no avail. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy paste special
You don't happening to be running multiple instances of Excel?
CGCPA wrote: Thanks for the reply Bob, yes I have correctly selected the cells and have right clicked in the target area "destination" - I have gone to the clipboard hit copy from there then attempted to go to destination then "paste " from the clipboard. I've been doing this (complex spreadsheets) for 30 years and have tried all the options. I'm baffled to say the least. There is a conflic somewhere that is killing excel, no viruses, running MS sql 2005 application programs, Prevasive Database of Peachtree, Quickbooks, applications in Access, other acctg applications and etc . Your help is greatly appreciated "Bob I" wrote: R-click on the destination and select Paste Special. CGCPA wrote: Excel 2007 - when attempting to "copy - paste" both from within the same worksheet and from other open worksheets the drop down menu in the clipboard does not give me the Paste special option as described in the Help topics (as was available in thye excel 2003) right clicking paste in the target area gives me the paste special option but when I click it it opens in a window that only allows the options of "unicode text" or "text". There is no menue of options as in 2003. Where is my copy special features? I have uninstalled and reinstalled Office 2007 with no avail. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy paste special
Have done that at times, that was Dell's solution as they stated that Excel
2007 has a diff memory allocation scheme - but that does not solve the problem either way. There just does not seem to be an explanation form MS on where this message originates i.e. what about resources, is it paging, ram, CPU what in that program triggers this message.It simply suggest me closing other applications of spreadsheets. But as I mentioned, these are the same programs, opened the same time and way as in excel 2002. So it not a problem with too much running, its a problem with excel 2007 compatibility with something. There is a root cause problem. Withou uninstalling one app at a time , there is no way to diagnois. Best thing and cheapest is to trash this whole system, Office 2007 Excel first and re-purchase an HP with Office 2003. Give the time lost, this has cost me easily more in lost productivity and billing than the system. I only wish my programs would run on the Apple Mac. I would change today "Bob I" wrote: You don't happening to be running multiple instances of Excel? CGCPA wrote: Thanks for the reply Bob, yes I have correctly selected the cells and have right clicked in the target area "destination" - I have gone to the clipboard hit copy from there then attempted to go to destination then "paste " from the clipboard. I've been doing this (complex spreadsheets) for 30 years and have tried all the options. I'm baffled to say the least. There is a conflic somewhere that is killing excel, no viruses, running MS sql 2005 application programs, Prevasive Database of Peachtree, Quickbooks, applications in Access, other acctg applications and etc . Your help is greatly appreciated "Bob I" wrote: R-click on the destination and select Paste Special. CGCPA wrote: Excel 2007 - when attempting to "copy - paste" both from within the same worksheet and from other open worksheets the drop down menu in the clipboard does not give me the Paste special option as described in the Help topics (as was available in thye excel 2003) right clicking paste in the target area gives me the paste special option but when I click it it opens in a window that only allows the options of "unicode text" or "text". There is no menue of options as in 2003. Where is my copy special features? I have uninstalled and reinstalled Office 2007 with no avail. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy paste special
Definitely sounds like you are running two instances of Excel.
Close one down and open both workbooks in one instance. through FileOpen Gord Dibben MS Excel MVP On Tue, 9 Dec 2008 09:00:00 -0800, CGCPA wrote: Have done that at times, that was Dell's solution as they stated that Excel 2007 has a diff memory allocation scheme - but that does not solve the problem either way. There just does not seem to be an explanation form MS on where this message originates i.e. what about resources, is it paging, ram, CPU what in that program triggers this message.It simply suggest me closing other applications of spreadsheets. But as I mentioned, these are the same programs, opened the same time and way as in excel 2002. So it not a problem with too much running, its a problem with excel 2007 compatibility with something. There is a root cause problem. Withou uninstalling one app at a time , there is no way to diagnois. Best thing and cheapest is to trash this whole system, Office 2007 Excel first and re-purchase an HP with Office 2003. Give the time lost, this has cost me easily more in lost productivity and billing than the system. I only wish my programs would run on the Apple Mac. I would change today "Bob I" wrote: You don't happening to be running multiple instances of Excel? CGCPA wrote: Thanks for the reply Bob, yes I have correctly selected the cells and have right clicked in the target area "destination" - I have gone to the clipboard hit copy from there then attempted to go to destination then "paste " from the clipboard. I've been doing this (complex spreadsheets) for 30 years and have tried all the options. I'm baffled to say the least. There is a conflic somewhere that is killing excel, no viruses, running MS sql 2005 application programs, Prevasive Database of Peachtree, Quickbooks, applications in Access, other acctg applications and etc . Your help is greatly appreciated "Bob I" wrote: R-click on the destination and select Paste Special. CGCPA wrote: Excel 2007 - when attempting to "copy - paste" both from within the same worksheet and from other open worksheets the drop down menu in the clipboard does not give me the Paste special option as described in the Help topics (as was available in thye excel 2003) right clicking paste in the target area gives me the paste special option but when I click it it opens in a window that only allows the options of "unicode text" or "text". There is no menue of options as in 2003. Where is my copy special features? I have uninstalled and reinstalled Office 2007 with no avail. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy paste special
Thanks Gord -- but really I'm running only one instance - I often run out to
task master to check rogue process and auto-updates which jump in uninvited. Let a Java update get started and office 2007 goes nuts. Both workbooks are in one instance, Simple worksheets, pages of financial statements, separtae pages of financials on each of 10-12 tabs 20 columns wide , 60 lines deep, few formulas, little formating. I have done this before, so I know it works, why the "now it doesn't" even after re-install of prog? Who in microsoftland understands this program? 2003 was just slick, some rookie with bright ideas at MS royally messed up the most productive software we accountants had. But you guys are very gracious. "Gord Dibben" wrote: Definitely sounds like you are running two instances of Excel. Close one down and open both workbooks in one instance. through FileOpen Gord Dibben MS Excel MVP On Tue, 9 Dec 2008 09:00:00 -0800, CGCPA wrote: Have done that at times, that was Dell's solution as they stated that Excel 2007 has a diff memory allocation scheme - but that does not solve the problem either way. There just does not seem to be an explanation form MS on where this message originates i.e. what about resources, is it paging, ram, CPU what in that program triggers this message.It simply suggest me closing other applications of spreadsheets. But as I mentioned, these are the same programs, opened the same time and way as in excel 2002. So it not a problem with too much running, its a problem with excel 2007 compatibility with something. There is a root cause problem. Withou uninstalling one app at a time , there is no way to diagnois. Best thing and cheapest is to trash this whole system, Office 2007 Excel first and re-purchase an HP with Office 2003. Give the time lost, this has cost me easily more in lost productivity and billing than the system. I only wish my programs would run on the Apple Mac. I would change today "Bob I" wrote: You don't happening to be running multiple instances of Excel? CGCPA wrote: Thanks for the reply Bob, yes I have correctly selected the cells and have right clicked in the target area "destination" - I have gone to the clipboard hit copy from there then attempted to go to destination then "paste " from the clipboard. I've been doing this (complex spreadsheets) for 30 years and have tried all the options. I'm baffled to say the least. There is a conflic somewhere that is killing excel, no viruses, running MS sql 2005 application programs, Prevasive Database of Peachtree, Quickbooks, applications in Access, other acctg applications and etc . Your help is greatly appreciated "Bob I" wrote: R-click on the destination and select Paste Special. CGCPA wrote: Excel 2007 - when attempting to "copy - paste" both from within the same worksheet and from other open worksheets the drop down menu in the clipboard does not give me the Paste special option as described in the Help topics (as was available in thye excel 2003) right clicking paste in the target area gives me the paste special option but when I click it it opens in a window that only allows the options of "unicode text" or "text". There is no menue of options as in 2003. Where is my copy special features? I have uninstalled and reinstalled Office 2007 with no avail. |
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) | |||
Copy and Paste special | Excel Discussion (Misc queries) | |||
Copy; Paste; Paste Special are disabled | Excel Discussion (Misc queries) | |||
Copy & paste special | Excel Worksheet Functions | |||
Copy - Paste Special | Excel Discussion (Misc queries) |