Excel pauses 2-3 seconds after enter data in a cell

au2010

New Member
Joined
Jun 7, 2012
Messages
21
Hello. I'm having a problem with one specific Excel file. Excel seems to "pause" (become non-responsive) for 2-3 seconds after I type a number or text in a cell and then press "Enter" or an arrow key to move to another cell. It's almost as if Excel is recalculating - but recalculation is set to Manual.

Any ideas on what could be causing this?

Some additional info that may be relevant:

1) The problem only happens with one specific file. It doesn't affect other Excel workbooks, even other workbooks that are open at the same time.
2) I don't think it's a matter of file size. I have other Excel workbooks that are much larger where this never happens.
3) As noted above, Calculation is set to Manual.
4) The "pause" only happens if I type a number or text in a cell and then press "Enter" or an arrow key to move to another cell - it does NOT happen if I copy and paste a value.
5) It also does NOT seem to happen if I type numbers or text into a cell that is NOT referenced by formulas elsewhere in the workbook. But if the cell is referenced by formulas, the pause does occur.
6) The workbook contains a large number of sheets (about 50) and many references to other workbooks, but this is nothing unusual for me - I have quite a few Excel workbooks with more tabs and more external references that never give me this "pause" problem.
7) If I select more than 1 one tab and type in numbers or text, the pause does NOT happen. But if I ungroup sheets, the "pause" starts to happen again.
8) Quitting and restarting Excel does not help.
9) Excel version: Excel 2016
10) File extension: .xlsx

Any insights greatly appreciated.

Thank you.
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

au2010

New Member
Joined
Jun 7, 2012
Messages
21
UPDATE: Turns out my file had hundreds of hidden named ranges. Unhiding those ranges and deleting them seems to have fixed the "Pause" problems.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,119
Messages
5,466,796
Members
406,499
Latest member
COACHTEEJ

This Week's Hot Topics

Top