Excel97 workbook crashes after changes to columns

  • Thread starter Thread starter Scampa7
  • Start date Start date
S

Scampa7

I have been working on an Excel97 workbook (in NT4). This workbook has
main sheet with various formatting added by a Worksheet_Chang
procedure. This sheet is basically a database with about 60 columns an
500+ rows. There are a number of other sheets, but I have not made an
changes to these.

All had been fine until I attempted to remove a column within the dat
area, and add another two columns to the left of it. I also added
columns at the end of the data area. When I tried to open the workboo
after saving and closing, it crashed with an 'access violation
application error.

I have since tried removing all locked cells and protection from th
sheet, and saving again but it still crashes when I try to open it.

Any ideas on finding this problem would be very gratefully received
 
I have just tried deleting and adding columns to the same workbook on my
pc at home which has Excel2000, and Win2000.
Anyone have any ideas why this might work on Excel2000 / win2000 and
not on Excel97 / NT4?
 
Just a guess.

As excel grows, it seems to handle "problem" workbooks better. xl2002 can open
some workbooks that xl97 and xl2k can't.

(I think I'd try rebuilding your workbook from scratch to see if that helps.
Maybe the workbook is corrupted enough to cause problems for xl97--but not for
the others.)
 
Back
Top