Solved AppHangB1 error in Excel - very slow

Dell Optiplex 380 mini-tower desktop - c...
January 4, 2012 at 10:12:18
Specs: Windows 7, 2.9GHz/3GB
Hi Heroes,

I've got quite a big spreadsheet (1.4MB) with a lot of calculations on it but nothing Excel shouldn't be able to handle. When I try to copy and paste it causes excel to go "Not responding"

Any help on how to clear this up very much appreciated.

Thanks in advance

Charlie C

See More: AppHangB1 error in Excel - very slow

Report •

January 4, 2012 at 15:34:10
Have you tried deleting unused Columns & Rows.
Go to the last cell in the Row/Column then select all the blank Row/Columns to the end and delete them. Make sure you remove any formatting like borders, colors, etc.

Also, make sure you are using only the required range of cells in your formula, not
the whole Row/Column.

Also you can sometime get a bit of a reduction if you:
Save as HTML, open the HTML and re-save as XLS or XLSX


Report •

January 4, 2012 at 23:55:23
Thanks very much Mike. I've had a go at that to no avail. I think the issue is the AppHangB1 error in the spreadsheet.

Theonly advice I've come across on the web is for Vista and I couldn't see the relevant options for Windows 7 on the Control Panel....

Try going this: go to control panel, then system maintenance, pick system, choose advance settings, click performance setttings, choose Data Execution Protection, click add, make sure you are looking at your desktop (if that is where your Excel program icon is), scroll down to the icon, click on it and hit open, hit apply and okay.

Report •

January 5, 2012 at 03:45:57
✔ Best Answer
If your using 2007 or 2010 try a Diagnostic:

Running Microsoft Office Diagnostics from within Excel/Word

Click the Microsoft Office button
Click on the Excel/Word Options button to bring up the Excel Options dialog box (at the bottom of window)
Click on the Resources button in the left hand pane
Click on the Diagnose button in the right hand pane
Click Continue
Click Run Diagnostics

Running Microsoft Office Diagnostics from the Start Menu

Click on the Start button
Click All Programs
Click Microsoft Office folder
Click Microsoft Office Tools
Click Microsoft Office Diagnostics
Click Continue
Click Run Diagnostics

You could also try starting in SAFE Mode:

click Run

Enter: excel /s

If you get an error message, you may have to use the complete path, something like:

C:\Program Files\Microsoft Office\Office\Excel.exe /s

Safe Mode forces Excel to bypass:

All files in any Excel startup folder.

Add-ins: The Addins dialog box still displays the
selected addins, but, the addins are not loaded.

Excel toolbars (Excel.xlb or <username>.xlb): The
original installation default toolbar settings are used.

Excel specific registry information: The original
installation default registry settings are used.

If this solves your problem, then the culprit resides somewhere in the above locations.


Report •

Related Solutions

Ask Question