Excel crashing when saving a template

Harvey

Well-known Member
Joined
Nov 18, 2004
Messages
953
Hi,

I have a template that runs code on Workbook_BeforeClose, Workbook_Deactivate and Workbook_Open. About 20% of the times the workbook is saved, Excel crashes. The template has a fair number of ActiveX controls, ie. comboboxes and lists. There is also a second document opened, that contains data which is used in the document. I have no single clue why the application crashes. It seems to happen at random, but more often when I have not saved for a while. Is there anyone that can help me out here?
Thanks a lot for any suggestions.

Regards,

Martien

I forgot to say: Excel version is 2002 + SP-2
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Harvey

Well-known Member
Joined
Nov 18, 2004
Messages
953
the problem seems to occur always when i have filled a certain combobox, referring to a 10k items list, and have run a macro afterwards. Should I post the macro? (its very large)
 

Harvey

Well-known Member
Joined
Nov 18, 2004
Messages
953
Is there noone who can help me? :cry:
I have already found out that it can have something to do with network settings. The template is on a network drive, and the result will also be saved somewhere on the network. I think the network uses Novell, but I'm not sure.
Please :rolleyes: me, I am completely stuck. I can send you the workbooks if neccessary.
 

Harvey

Well-known Member
Joined
Nov 18, 2004
Messages
953
I tested the workbooks on a local harddisk instead of network, with no effect. The application still crashes.
 

Harvey

Well-known Member
Joined
Nov 18, 2004
Messages
953
one last time, can anyone please help me? I'm completely stuck. The application won't save whenever the filename is changed.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,532
Messages
5,572,729
Members
412,482
Latest member
arooshrana2
Top