Excel crashes when I Insert>CopiedRows

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
Back
Top