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
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,797
Messages
5,833,738
Members
430,228
Latest member
Normano

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top