Troubleshoot Microsoft Excel 2007 hang and freeze during calculation

[Sunny foong king fung]

Briefly explain your current issue(s)

Excel 2007 not responding during calculation 1%

Steps taken to resolve, but have been unsuccessful

Tried manual under formulas didn't work because user want to calculate.

Hi guys,

My customer facing this issue Excel 2007 not responding during Calculation 1% checked the task manager cpu usage running 100%.She has allot formulas and trying to combine it and need to be submitted.
Hope you guys know a way to solve it.

Spec Laptop
HP Elitebook 840G1 - 8gb ddr3L ram

Thanks,
Sunny

 

[JM Safe]

Hello @Sunny foong king fung , first of all welcome to our community.

Do the other functions work well?

Anyway, please try this solution:

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

Source: https://support.microsoft.com/en-us/kb/2012541

Or you can try to put your calculation into an array:

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