Forums
New posts
Search forums
News
Security News
Technology News
Giveaways
Giveaways, Promotions and Contests
Discounts & Deals
Reviews
Users Reviews
Video Reviews
Support
Windows Malware Removal Help & Support
Mac Malware Removal Help & Support
Mobile Malware Removal Help & Support
Blog
Log in
Register
What's new
Search
Search titles only
By:
Search titles only
By:
Reply to thread
Menu
Install the app
Install
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Forums
Software
Software Troubleshooting
Microsoft Excel 2007 hang and freeze during calculation
Message
<blockquote data-quote="JM Safe" data-source="post: 508965" data-attributes="member: 35684"><p>Hello [USER=52218]@Sunny foong king fung[/USER] , first of all welcome to our community.</p><p></p><p>Do the other functions work well?</p><p></p><p>Anyway, please try this solution:</p><p></p><p>[CODE]Look for addins or Com Addins.</p><p></p><p>For Addins:</p><p>Start Excel, do an Alt-F11, which will take you to the VBA Editor Window.</p><p>Do a CTRL-R which will take you to Project Explorer.</p><p>In Project Explorer, there should be only one Progect (Book 1).</p><p>If there are additional projects, we will need to remove them.</p><p></p><p>Go back to Excel, and select the Office Button | Excel Options | Addins | Manage</p><p>Excel Addins | Go and unselect all addins that are checked.</p><p>While in Excel Options, Select Advanced | General | “At Startup open all files in “</p><p>and make sure this box is blank.</p><p></p><p>Go to C:\Program Files\Microsoft Office\Office 12\XLStart and remove any files in</p><p>this directory</p><p>Go to C:\Documents and Settings\<user name>\Application</p><p>Data\Microsoft\Excel\XLStart and remove any files in this directory.</p><p></p><p>Close then Restart Excel, the Project Explorer in the VBA Editor should have only</p><p>one Project, Book 1.</p><p></p><p>For Com Addins:</p><p></p><p>Start | Run | Regedit | Enter</p><p></p><p>If Excel is not under the Office Key, there are no Com Addins.</p><p></p><p>HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins and see how many addins</p><p>are there.</p><p>Select each addin, and in the Right Window, select LoadBehavior.</p><p>Right Click on LoadBehavior | Modify | and set it to zero (0). The normal setting</p><p>is 3.</p><p></p><p>HKEY_LOCAL_MACHINE\Software\Microsoft\Office\Excel\Addins and see how many addins</p><p>there are.</p><p>Set each addisn’s LoadBehavior to zero (0).</p><p></p><p>If this is a 64 bit machine, look for addins at :</p><p>HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\Excel\Addins[/CODE]</p><p></p><p>Source: <a href="https://support.microsoft.com/en-us/kb/2012541" target="_blank">https://support.microsoft.com/en-us/kb/2012541</a></p><p></p><p>Or you can try to put your calculation into an array:</p><p></p><p>[CODE]Array formulas are powerful, but they must be used correctly. It's important not to add more cells in your array than you need, when a cell in your array needs to calculate, it calculates all cells that are referenced in that formula.</p><p></p><p>For more information on how arrays work please see Excel 2010 Performance: https://msdn.microsoft.com/en-us/library/office/ff726673%28v=office.14%29.aspx</p><p>[/CODE]</p></blockquote><p></p>
[QUOTE="JM Safe, post: 508965, member: 35684"] Hello [USER=52218]@Sunny foong king fung[/USER] , first of all welcome to our community. Do the other functions work well? Anyway, please try this solution: [CODE]Look for addins or Com Addins. For Addins: Start Excel, do an Alt-F11, which will take you to the VBA Editor Window. Do a CTRL-R which will take you to Project Explorer. In Project Explorer, there should be only one Progect (Book 1). If there are additional projects, we will need to remove them. Go back to Excel, and select the Office Button | Excel Options | Addins | Manage Excel Addins | Go and unselect all addins that are checked. While in Excel Options, Select Advanced | General | “At Startup open all files in “ and make sure this box is blank. Go to C:\Program Files\Microsoft Office\Office 12\XLStart and remove any files in this directory Go to C:\Documents and Settings\<user name>\Application Data\Microsoft\Excel\XLStart and remove any files in this directory. Close then Restart Excel, the Project Explorer in the VBA Editor should have only one Project, Book 1. For Com Addins: Start | Run | Regedit | Enter If Excel is not under the Office Key, there are no Com Addins. HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins and see how many addins are there. Select each addin, and in the Right Window, select LoadBehavior. Right Click on LoadBehavior | Modify | and set it to zero (0). The normal setting is 3. HKEY_LOCAL_MACHINE\Software\Microsoft\Office\Excel\Addins and see how many addins there are. Set each addisn’s LoadBehavior to zero (0). If this is a 64 bit machine, look for addins at : HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\Excel\Addins[/CODE] Source: [URL]https://support.microsoft.com/en-us/kb/2012541[/URL] Or you can try to put your calculation into an array: [CODE]Array formulas are powerful, but they must be used correctly. It's important not to add more cells in your array than you need, when a cell in your array needs to calculate, it calculates all cells that are referenced in that formula. For more information on how arrays work please see Excel 2010 Performance: https://msdn.microsoft.com/en-us/library/office/ff726673%28v=office.14%29.aspx [/CODE] [/QUOTE]
Insert quotes…
Verification
Post reply
Top