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.