Excel crashes when I Insert>CopiedRows

G

Guest

Does any body know why Excel crashes when I Copy>Row then choose
Insert>Copied Rows? This only happens on one sheet in my Estimate workbook
and it's always the same sheet. And Excel doesn't always crash. I can copy
rows and insert the copied rows without any problem on other sheets in the
same Estimate workbook. And to further frustrate me I can open other saved
Estimate workbooks and Copy>Rows and Insert>Copied>Rows on the offending
sheet without incident. Any body have experience with this type of problem?
Thanks for your help. Excel 2002 SP-3.
 
B

Bill Manville

Clearly there is some problem with that particular sheet.

I would try rebuilding the calculation chain (Edit / Replace / = with =
/ Replace All). If that doesn't help, I would rebuild the workbook
using as a basis one of your saved books that doesn't exhibit the
problem.

Bill Manville
MVP - Microsoft Excel, Oxford, England
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Paste failed in excel file migrated from Excel 2003 to Excel 1
Copy row, Insert>Copied>Cells crashes Excel 0
Semi-Automated Copy and Insert 2
data to summary sheet for a dummy 0
Excel 2007 - Shared Workbook Crashes When i try to save 1
Excel freezes after I insert a new row 0
How do I copy or move a worksheet to another workbook? 6
Reading data from one sheet into another sheet 1

Top