Strange Error Message when trying to insert column

Yepper · Apr 19th, 2002, 03:55 PM

Hello. In an Excel 97 file, I had copied a worksheet, grouped the two identical worksheets, and then tried to insert a column. I immediately received the following "Program Error" message on my screen: "EXCEL.exe has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created." The file and Excel close automatically. I tried to insert a column in the same file from another PC, and the same error message appeared. The worksheet has external references but no names.

Questions: How can I determine what the problem is? What is an "error log" and where do I locate it?

Thank you!

Damon Ostrander · Apr 19th, 2002, 04:27 PM

Hi Yepper,

With this type of problem the log file is generally of no help, except for the Excel developers. This problem is one that the Excel developers didn't foresee occurring and therefore didn't write any error handling or prevention code for it. All that said, in this particular case in which you have described what you are trying to do, I'm virtually certain the problem is because you are applying a paste or insert operation to the grouped set of sheets, and that the problem will go away if you insert the columns into the sheets one at a time (using a For..Each loop, for example).

Apr 19th, 2002, 04:27 PM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi Yepper, With this type of problem the log file is generally of no help, except for the Excel developers. This problem is one that the Excel developers didn't foresee occurring and therefore didn't write any error handling or prevention code for it. All that said, in this particular case in which you have described what you are trying to do, I'm virtually certain the problem is because you are applying a paste or insert operation to the grouped set of sheets, and that the problem will go away if you insert the columns into the sheets one at a time (using a For..Each loop, for example). __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 19th, 2002, 03:55 PM	#1
Yepper Board Regular Join Date: Apr 2002 Posts: 67	Hello. In an Excel 97 file, I had copied a worksheet, grouped the two identical worksheets, and then tried to insert a column. I immediately received the following "Program Error" message on my screen: "EXCEL.exe has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created." The file and Excel close automatically. I tried to insert a column in the same file from another PC, and the same error message appeared. The worksheet has external references but no names. Questions: How can I determine what the problem is? What is an "error log" and where do I locate it? Thank you!