Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 crashes when trying to send a workbook | Excel Discussion (Misc queries) | |||
Excel 2003 crashes when open new workbook | Excel Discussion (Misc queries) | |||
Excel crashes when I try to Delete Columns | Excel Discussion (Misc queries) | |||
Error message opening Excel97 workbook | Excel Discussion (Misc queries) | |||
Excel97 workbook crashes after changes to columns | Excel Programming |