Excel97 workbook crashes after changes to columns
 

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

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Excel97 workbook crashes after changes to columns
 

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?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements

Excel97 workbook crashes after changes to columns
 

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.)

Scampa7 wrote:

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?

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements

--

Dave Peterson