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!!!
--
sb
"steve" wrote in message
...
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