Excel crashes when entering data...

[Tony]

I posted this as a reply in another post, but thought I'd create a new
discussion so that it is better highlighted...

I had this issue when I was using Excel 2004, and the same problem
exists even after I upgraded to Excel 2008. ALL previous versions of
Office were removed during the install of Office 2008.

The error...

There's a small group of cells in a worksheet that, when any data is
entered, causes Excel to crash. For instance, in the particular
workbook I'm working in, there are 3 worksheets. Only one of the
sheets has an issue. When using this sheet, the group of cells at
E85:G89 cannot have any data entered. The cells at I81:J91 will not
affect a formula in cell L92 that totals all the formulas in row 92
(that are themselves sums of the columns above).

I recreated the workbook from scratch in Excel 2008 and encountered
the same problems. The original file was created in Excel 2004.

At this point, I'm not sure whether to think there's corruption in the
file, program, or system. There are other, similar files with the same
problem; those files are the same except for a different date range
(though the same kind of data; we use one file for each month).

Any ideas or do I need to provide more information?

Thanks!
Tony

 

[Bob Greenblatt]

I posted this as a reply in another post, but thought I'd create a new
discussion so that it is better highlighted...

I had this issue when I was using Excel 2004, and the same problem
exists even after I upgraded to Excel 2008. ALL previous versions of
Office were removed during the install of Office 2008.

The error...

There's a small group of cells in a worksheet that, when any data is
entered, causes Excel to crash. For instance, in the particular
workbook I'm working in, there are 3 worksheets. Only one of the
sheets has an issue. When using this sheet, the group of cells at
E85:G89 cannot have any data entered. The cells at I81:J91 will not
affect a formula in cell L92 that totals all the formulas in row 92
(that are themselves sums of the columns above).

I recreated the workbook from scratch in Excel 2008 and encountered
the same problems. The original file was created in Excel 2004.

At this point, I'm not sure whether to think there's corruption in the
file, program, or system. There are other, similar files with the same
problem; those files are the same except for a different date range
(though the same kind of data; we use one file for each month).

Any ideas or do I need to provide more information?

Thanks!
Tony

I saw this post in another thread. Do you mean you quit Excel, restarted it,
and keyed new data into the new sheet, and then had a problem with I81:J91?
If so, this is really weird.

By any chance do you have a worksheet template? If so, this may be corrupt.
If the file contains no proprietary data, email it to me and I'll see if I
can see what the problem is.