Slow enter on sheet

  • Thread starter Thread starter steve
  • Start date Start date
S

steve

Working Excel97 SR2, Windows 2000

I have a workbook designed to take input for a form.
The input sheet has 38 comboboxes.

When I make an entry and hit the enter key, there is a momentary
hesitation before advancing to the next cell. (I do not get this hesitation
on a new workbook if my workbook is closed, but do if it is open).

And if I put a formula on the form sheet referencing the input sheet, all I
get is the formula "=InputPage!A2" instead of the results of A2. Even if
the formula refers to the same sheet "=A2" I still just get the formula.

The workbook also has names such as
MyName refers to: =OFFSET(Lists!R2C13,0,0,COUNTA(Lists!C13)-1,1)

Now the things I have done:
1. Turned off all the Add-ins to no effect
2. Commented out ALL code to no effect
3. Code Cleaner to clean the workbook to no effect
4. Tried rebuilding the workbook in a new workbook using copy/paste.
Just as I think I'm getting somewhere - the new workbook crashes and
is too corrupt to reopen.

Before I start to rebuild the workbook from scratch I would appreciate any
insight that might help!

Other workbooks seem to be running just fine. And I recently had Excel
Windows reloaded on my computer (but maybe its been long enough???)

And my ng reader has been sporadic of late so please Cc: me with your
reply.

Thanks!!!
 
Perhaps you have recalculation set to automatic. If you set it to manual, does it speed up the process?

Sounds like you have the sheet set in Formula View. Check Tools|Options and the setting for Formulas on the View tab. (Or use Ctrl `
or Ctrl ~ to toggle the view).
 
At last, my reader is downloading again!!!!!!!!!! Whoop!!!

Have been making some progress.

Found my form page to be corrupted. Totally rebuilt it without copy/paste.
Working better.

Removed all Offset formulas from my names. Now have code to build the
references. Now my enter speed is back to normal.

And all formulas are working as they should!!!

There is definitly some kind of corruption involved. But am not sure where
it was (may still be there). But rebuilding the form page has helped.

Things appear to be working OK.

My thanks to all those who have responded!!! (Some have sent emails
directly and given me some good input).

I will continue to search for a reason why my Offset name formulas were
causing a problem. But for this project that is in the past.

Wish me luck. I am only the final legs of getting this thing to work...

Again - thanks to all for their support!!!
 
John,

Thanks for getting back to me. (am starting to see posts, but this one
hasn't popped up)(got your message from Developers dex).

Now let's see.
Tried calculation Auto and Manual. In manual things
speed up to normal.
Made sure I wasn't set to view formulas.
The problem persists (in Auto calculation).

Removed the Offset references in the names and voile...
the delay disappeared. So I am going to use code to set
the names.

Don't understand why the Offset formulas in the names is
causing a problem since I have been using these since forever.

Again, thanks...

steve
 
Back
Top