sides of march (Brian DeMarzo)

Thoughts on life, liberty, and information technology

Excel crashes, and flooding Microsoft with error reports

5.6.2007

Excel 2007 crashed on me while I was scrolling vertically using the mouse wheel. Impressively, Excel was able to recover, apparently right back where I left off scrolling.

I continued trying to scroll (again with the mouse wheel), and once again, after about 100 or so rows scroll by, Excel crashes again. This time, I choose to send the error report.

Recovery again works like a charm (at least one thing is working right). I try scrolling with the scroll bar; no crash. I try page-down and arrow keys; no crash. I go to a different part of the document and scroll with the mouse wheel; crash after about 100 rows pass by.

“Send error report” clicked again.

This is getting fun, so I’m going to do it about 20 more times.

12 responses to “Excel crashes, and flooding Microsoft with error reports”

Travis

2007.06.26

You really think anyone at MS pays attention to those error reports?

LikeLike

Reply
brian

2007.06.27

No, but if someone does, I feel sorry for them. 🙂

LikeLike

Reply
Joe

2007.10.24

I have noticed the same behaviour in Excel 2003. But only since about May 07. Possibly an MS Update glitch. This thread is the only info I have found on it. But I really havent been looking that hard. I always Send the Error message.

LikeLike

Reply
brian

2007.10.24

One day I want to hear that someone was contacted by Microsoft regarding the error message they sent. 🙂

LikeLike

Reply
Justin

2008.02.22

Has there been any resolutions to this issue. It is driving me crazy!!
thanks

LikeLike

Reply
JDub

2008.04.02

I have the same problem. I use a lot of large excel files, with multiple sheets that have 2000 lines each, so it’s getting pretty irritating.

LikeLike

Reply
Quoc

2008.05.08

Are you using the excel 2003 format? It crashed when i scrolled everytime on that format but not on the 2007 format.

LikeLike

Reply
brian

2008.05.08

I may have been — if your suggestion works, you’ve solved many a person’s grief!

LikeLike

Reply
John H

2008.08.05

I’ve been using Excel 2007 with XP for months with only occasional crashes, usually with huge (500,000+ lines) spreadsheets. Now I have Vista for business, 10 times the processor, 5 times the RAM, and now I can barely open a 500,000 spreadsheet without crashing!

LikeLike

Reply
Adrian

2009.02.23

I think i may have found a work around, whenever i scrolled on a
sheet which only contained text and over 200 rows, Excel Crashed.

When i got the error report i clicked on Debug (as i have VS2005)
and it came back with an access voilation. I went into the Excel
Options and played around. This is what i found…

Open Excel options
Select Advanced
Scroll down till you get to the option “Show Formulas in cells
instead of their calculated Results”
If it is not checked place a check in the box.
You should now be able to scroll with out Excel crashing (so far anyway).

Note: If you have formulas in your spreadsheet i’m not sure what you’ll see.

LikeLike

Reply
Jo Werner

2009.02.27

I see a similar bug with the scroll wheel in Excel 2007 / xlsx or xlsb file format:

When scrolling vertically, some areas of cells within the spread sheet are shown blank.
In cells at the top or bottom of the blank area, values are only shown half. The cells do have values.

When I scroll horizontally over this area, moving it out and into the screen, the area is shown correkt again.

This doesnot appear using the PageUp or PageDown keys!

LikeLike

Reply
SLS

2010.08.30

this problem occure cause of the version of Excel document ,specially when you try to copy the file ,clear all cells and inter new data .
so the best solution is to open the old file ,clear all the cells and import new data ,then do save as ( the first choice ) from options .

LikeLike

Reply