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.
Popularity: 33% [?]
Comments 11
You really think anyone at MS pays attention to those error reports?
Posted 26 Jun 2007 at 5:56 pm ¶No, but if someone does, I feel sorry for them.
Posted 27 Jun 2007 at 3:54 pm ¶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.
Posted 24 Oct 2007 at 2:10 pm ¶One day I want to hear that someone was contacted by Microsoft regarding the error message they sent.
Posted 24 Oct 2007 at 2:11 pm ¶Has there been any resolutions to this issue. It is driving me crazy!!
Posted 22 Feb 2008 at 11:55 am ¶thanks
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.
Posted 02 Apr 2008 at 3:10 pm ¶Are you using the excel 2003 format? It crashed when i scrolled everytime on that format but not on the 2007 format.
Posted 08 May 2008 at 12:28 pm ¶I may have been — if your suggestion works, you’ve solved many a person’s grief!
Posted 08 May 2008 at 1:04 pm ¶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!
Posted 05 Aug 2008 at 1:53 pm ¶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.
Posted 23 Feb 2009 at 7:11 pm ¶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!
Posted 27 Feb 2009 at 5:12 am ¶Post a Comment