{"id":1550,"date":"2011-02-15T10:24:10","date_gmt":"2011-02-15T09:24:10","guid":{"rendered":"https:\/\/www.peppercrew.nl\/?p=1550"},"modified":"2011-05-19T15:00:33","modified_gmt":"2011-05-19T14:00:33","slug":"excel-2010-crashes-on-saveas-macro","status":"publish","type":"post","link":"https:\/\/ingmarverheij.com\/en\/excel-2010-crashes-on-saveas-macro\/","title":{"rendered":"Excel 2010 crashes on Save(as) \/ Macro"},"content":{"rendered":"<p>After working multiple days on an Excel worksheet with lots a data, charts en Macro&#8217;s the worksheet somehow crashes today. Altough I haven&#8217;t found out what iniated the problem (maybe the installation of Adobe Reader X?) I have found a &#8220;solution&#8221; to the problem.<\/p>\n<p>First of all the <strong>symptoms<\/strong>.<br \/>\nAfter opening an Excel 2010 worksheet, with the Macros enabled (&#8220;Enable Content&#8221;), the worksheet can&#8217;t be saved. Saving the worksheet, or clicking on the Macros button (on the Developer tab), results in a crashing worksheet.<\/p>\n<p>In the event log the followin error is logged:<br \/>\n<code>Faulting application name: EXCEL.EXE, version: 14.0.4756.1000, time stamp: 0x4b9c0870<br \/>\nFaulting module name: VBE7.DLL, version: 7.0.15.90, time stamp: 0x4b7b2131<br \/>\nException code: 0xc0000005<br \/>\nFault offset: 0x0000000000220b24<br \/>\nFaulting process id: 0x186c<br \/>\nFaulting application start time: 0x01cbcce7fe8ef29f<br \/>\nFaulting application path: C:Program FilesMicrosoft OfficeOffice14EXCEL.EXE<br \/>\nFaulting module path: C:PROGRA~1COMMON~1MICROS~1VBAVBA7VBE7.DLL<br \/>\nReport Id: 46c04576-38db-11e0-9560-8697dfeafdc5<\/code><\/p>\n<p>Since the error only occurs when Macros (or VBA) is enabled, and the error references VBE7.DLL, I suspected the error to be in the VBA area.<br \/>\n<!--more--><\/p>\n<p>After some research I found out that a bad \/ corrupt reference is causing the problem.<br \/>\nAlthough clicking Macros causes Excel to crash, clicking Visual Basic doesn&#8217;t. So let&#8217;s click it.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1551\" src=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2011\/02\/Developer-Visual-Basic1.png\" alt=\"\" width=\"594\" height=\"223\" \/><\/p>\n<p>Next, open the project references dialog (Tools &gt; References).<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1552\" src=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2011\/02\/References-11.png\" alt=\"\" width=\"449\" height=\"360\" \/><\/p>\n<p>In this dialog (References &#8211; VBAProject) deselect a few references and acknowledge. You won&#8217;t be able to deselect references that are used, Excel will prevent you from this.<br \/>\nI deselected the reference &#8220;Microsoft Office 14.0 Object Library&#8221; and &#8220;OLE Automation&#8221;.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1553\" src=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2011\/02\/References-21.png\" alt=\"\" width=\"449\" height=\"360\" \/><\/p>\n<p>Now you can save the worksheet (and use Macros), the problem is solved!<br \/>\n<em>PS: After saving the worksheet you can select the same references you deselected before.<\/em><\/p>\n<p>Ingmar Verheij<\/p>","protected":false},"excerpt":{"rendered":"<p>After working multiple days on an Excel worksheet with lots a data, charts en Macro&#8217;s the worksheet somehow crashes today. Altough I haven&#8217;t found out what iniated the problem (maybe the installation of Adobe Reader X?) I have found a &#8220;solution&#8221; to the problem. First of all the symptoms. After opening an Excel 2010 worksheet, [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[17],"tags":[90,243,206,244,245],"class_list":["post-1550","post","type-post","status-publish","format-standard","hentry","category-office","tag-crash","tag-excel","tag-excel-2010","tag-references","tag-vbe7-dll"],"_links":{"self":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/1550","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/comments?post=1550"}],"version-history":[{"count":3,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/1550\/revisions"}],"predecessor-version":[{"id":2456,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/1550\/revisions\/2456"}],"wp:attachment":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/media?parent=1550"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/categories?post=1550"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/tags?post=1550"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}