Excel 2010 Not Responding

BW999
BW999 used Ask the Experts™
on
Excel 2010 32 bit hangs up.  Runnin Windows 7- 64 bit.   Running Macro for 2-3 minutes.  It has been thoroughly debugged on Office 2003.   Does not respond to Ctrl-Break or Esc, which would normally stop VBA execution.  The calculations are repetitive (do loop), and the hangup occurs after a few iterations, even though the same subroutines are being called.

HP Pavillion machine.  Could anti-virus be the culprit?  Norton Internet Security.

Diagnostic message received when I shut down all windows:  Can you interpret this:

Description:
  A problem caused this program to stop interacting with Windows.

Problem signature:
  Problem Event Name:      AppHangB1
  Application Name:      EXCEL.EXE
  Application Version:      14.0.4514.1004
  Application Timestamp:      4abf11d6
  Hang Signature:      516f
  Hang Type:      256
  OS Version:      6.1.7600.2.0.0.768.3
  Locale ID:      1033
  Additional Hang Signature 1:      516f987531c8eed8e78cb436448c26b4
  Additional Hang Signature 2:      758a
  Additional Hang Signature 3:      758abda5ba71186a2ca1999a93dbbb2c
  Additional Hang Signature 4:      516f
  Additional Hang Signature 5:      516f987531c8eed8e78cb436448c26b4
  Additional Hang Signature 6:      758a
  Additional Hang Signature 7:      758abda5ba71186a2ca1999a93dbbb2c

Read our privacy statement online:
  http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

If the online privacy statement is not available, please read our privacy statement offline:
  C:\Windows\system32\en-US\erofflps.txt
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Have you tried stepping theough the code with the debugger? It might be helpful to find out if the halt is happening on a particular line of code each time. If we're talking more than a couple of dozen keystrokes, try inserting a diagnostoc msgbox at the start or end of each loop iteration - bung in a loop counter and output its value in the msgbox each time around the loop. At least you'll find out how many loops it gets through before hanging.

As far as Norton causing the problem, if you turn it off, does the macro run OK?

Commented:
What was it that worked on this? Disabling Norton or doing the Debug steps?

I have the same issue for a PC with Excel 2010. As soon as there is any macro involved it tends to hang on File/Save As or File/Open

Author

Commented:
It is still an issue but is not particularly associated with File/Save or File/Open.  I have retreated to using Excel 2003, which runs faster and does not hang up.  I am going to try the 64-bit version of Excel 2010...  

Commented:
64bit Office is aweful (if you use Outlook). It still has issues that haven't been resolved fyi.

I fixed my problem by recreating the users profile. The user profile of the user was causing this to happen. Before this I tried to resetting the office settings (through registry), reinstalling, etc nothing worked.. besides redoing the users local profile...

If you can.. try to logon as a different user on your PC and see if the issue remains..

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial