Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
doctor9
 
Posts: n/a
Default why a delay when entering data

new in 2003, I am getting a delay when entering data before the cursor jumps
to the next cell. It seems to be related to iteration, but iteration didn't
produce this effect in 2000. Anyone know why and how to prevent the delay?
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

I don't know of a reason iteration would affect this.

But my first though was that you had a worksheet_change event firing that was
calling itself recursively until excel gave up trying.

If you open the workbook with macros disabled, do you have the same delay?

If no, try rightclicking on the worksheet tab and selecting view code. (If the
project is protected, you may need a password to see this.)

If you see code there, you may have found the problem. If you have trouble
fixing it, copy the code into a followup message. (Not the workbook!)

I'm sure someone will be able to help.

doctor9 wrote:

new in 2003, I am getting a delay when entering data before the cursor jumps
to the next cell. It seems to be related to iteration, but iteration didn't
produce this effect in 2000. Anyone know why and how to prevent the delay?


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 05:15 PM
entering data in certain cell Craig Sayers Links and Linking in Excel 1 December 30th 04 04:17 PM
Charting data ranges that change mikelee101 Charts and Charting in Excel 2 December 16th 04 11:07 PM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 11:56 AM
Data Table - Does it work with DDE links and stock tickers? Post Tenebras Lux Excel Discussion (Misc queries) 0 December 1st 04 05:15 PM


All times are GMT +1. The time now is 11:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"