Hello,

I am working on a spreadsheet where each time I scroll to
column "DV" the program closes and gives me the following
message:

EXCEL.exe has generated errors and will be closed by
Windows. You will need to restart the program. An error
log is being created.

This is a critical financial model that I am working on
and cannot be recreated very easily, so I am hoping
someone has a suggestion for fixing this problem. It does
not even tell me where the error log resides so I can know
what type of error I am dealing with. Any help is much
appreciated.

John

To find log file, search for drw*.log. In my PC, its in C:\Documents and Settings\All Users\Documents\DrWatson

Hi John

I am working on a spreadsheet where each time I scroll to
column "DV" the program closes and gives me the following
message:

What about if you go somwhere else?,
1. another sheet
2. the same sheet but a diffrent (later and eairly) place

There are quite a few error casues, but the message is, as you say
quite useless!(not unlike my spelling!)
Check out chip pearsons' excerllent site

http://www.cpearson.com/excel/StartupErrors.htm and the microsoft
links (have a look at the MSDN site while your there)

One thing that i have found, is that (esp) when using 97, controls
(such as drop down lists, buttons, etc) can casue errors, of the
nature you have described. - try coping the sheet, and removing these
from the page, if the error goes away - if it does you'll need to
stick such controlls on a userform.

Good Luck
Ross