View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default excel 2003 very unstable after copying a worksheet

Normally that shouldn't be a problem, of course. Before copy, do any/all the
following in stages as appropriate.

- Comment any code behind the worksheet and remove any ActiveX controls on
the sheet.

- Remove CF & DV

- Replace formulas with values

Regards,
Peter T

"Brian Murphy" wrote in message
...
I am finding that excel 2003 becomes very unstable after I manually
copy a worksheet. VBA macros that normally run fine halt before
finishing, and excel crashes soon thereafter.

Does anyone have any ideas why this would happen?

I am using XL 2003 SP2. When I try to install SP3 the updater
complains that it can't find a file that it needs on my original
XL2003 CD.

Thanks,

Brian