View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steve steve is offline
external usenet poster
 
Posts: 576
Default Slow enter on sheet

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!!!
--
sb