Data Entry

[Brian]

When I enter data in a cell, the hour glass appears and takes 60 seconds to
enter and move to another cell. How do I shut this function off to avoid the
60 sec delay?

 

[ShaneDevenshire]

Hi Brian,

First, the delay is probably occuring because your spreadsheet is
recalculating. You can turn this feature off by choosing Tools, Options,
Calculation, Manual.

But remember when you want your spreadsheet to update you must force
recalculation, one way is by pressing F9

 

[Brian]

Shane,

Thanks for the reply. I shut off the calc function earlier today with no
impact. Any other suggestions would be appreciated. It doesn't occur on
other files. Brian

 

[ShaneDevenshire]

Hi,

First I would check to see if there are any links - choose Edit, and see if
Edit Links is available.

Second, I would make sure no other Excel workbooks are open.

Third, I would check to see if there is any code in the file - open the VB
editor (press Alt+F11)

Select your file in the Project window and double click each object (sheet1,
sheet2, ... thisWorkbook) and check the modules folder if there is one. You
are looking for a macro that runs when you move or change something. A macro
named Worksheet_Change or Worksheet_SelectionChange or something like that.

 

[Brian]

Shane,

You should know I recently moved the workbook to a newer computer.
Previously, I used the sheet in Excel 2000 (Windows 98) with no issues. Now,
I'm trying to use it in Excel 2007 (XP Prof). But other workbooks do not
experience this annoying delay.

There is a linked worksheet I use with this workbook.

I opened the VB Editor. There is no code in the modules.
Brian