Jim was spot on about CF & DV, but not about going to bed! As I write it's
late afternoon here.

I don't have any more ideas until you've (Brian) checked out Jim's
suggestions.

Regards,
Peter T

"Jim Cone" wrote in message
...

I think Peter went to bed. CF...conditional formatting, DV...data
validation.
I have not seen any reference that says XL2007 performs better at
anything.

For what it's worth...
http://support.microsoft.com/kb/210684/en-us
"Copying worksheet programmatically causes run-time error 1004 in Excel"
http://support.microsoft.com/kb/215573/en-us
"You receive an error message when you add a chart to a workbook in Excel"

Moreover, does the problem stop after unchecking all add-ins in Tools |
Add-ins?
If so, add them back, one at a time, until the problem occurs.
You will then have a culprit. Repeat the process until all add-ins are
vetted.
--
updating Office 2003.
The worked for me...
Go to start | run | type services.msc
Search for office source engine
Change its status to automatic from disabled
--
Jim Cone
Portland, Oregon USA




"Brian Murphy"
wrote in message
Thank you for the reply, Peter.
The problem does not appear to be specific to any worksheet.
None of the sheets in my files have any code in their code modules.
There are no ActiveX controls on the sheets.
The problem is reproduceable on another computer with xl2003SP3.
I haven't tried Xl2007 yet. I don't know what to expect there.

What do you mean by CF and DV?
I have a collection of addins containing a great many macros. After a
sheet copy, some of the macros simply stop running before they are
finished, and many generate run time errors on different kinds of
statements.
One thing that always happens, is right after any the above problems
happens, excel becomes unstable. Can't select cells on a worksheet,
stuff like that. And then closing Excel triggers an outright crash.
I distribute my addins to a great many users, and I see this as a huge
problem.
Thanks,
Brian