Copy paste special

[CGCPA]

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.

 

[Bob I]

You don't happening to be running multiple instances of Excel?

 

[CGCPA]

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

 

[Gord Dibben]

Definitely sounds like you are running two instances of Excel.

Close one down and open both workbooks in one instance. through File>Open


Gord Dibben MS Excel MVP

 

[CGCPA]

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.

 

[desainad]

Paste Special Options not available..

I am facing the same problem. Were you able to resolve this?

Thanks,
Nirmala.

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.