Excel 2007 lock-up

  • Thread starter Thread starter gary
  • Start date Start date
G

gary

In Excel 2007, while saving a spreadsheet; selecting, deleting or
inserting columns; etc, an hourglass appears on my monitor and I can
hear the local hard disk spinning (the sound is more noticeable than
when the hard disk is not being accessed).

But, after the process ends, the hard disk repeatedly speeds up and
slows down and I can't work on the spreadsheet (the hourglass remains
on my monitor).

Task Manager's "Application" page shows that "Microsoft Excel" is "Not
Responding". And, the "Processes" page shows that the "Mem Usage" for
EXCEL.EXE does not change.

What is causing this problem and how can I resolve it?
 
One possible cause is that you have formulas looking at the entire worksheet
that should be limited to the data range...... If all else fails, send your
workbook to my address below and I'll try to take a look.
 
Hi Don,

My spreadsheet contains no formulas.

If the reason for the lock-up is recorded in the Event Log, which
log(s) and what Event Type(s) do I look at?

Gary
 
Back
Top