LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
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
Enter info in one sheet, auto enter in another based on one field The BusyHighLighter[_2_] New Users to Excel 1 August 1st 07 10:54 PM
Slow Spread Sheet Jasper Excel Worksheet Functions 2 February 1st 07 03:14 PM
Why is my Excel 2002 slow to enter cell? hkrdskh Excel Worksheet Functions 1 July 1st 06 06:25 PM
My excel sheet is slow to changes. Ash Excel Discussion (Misc queries) 2 June 29th 06 10:29 PM
enter data on 1 sheet and make it enter on next avail row on 2nd s Nadia Excel Discussion (Misc queries) 27 September 9th 05 03:39 PM


All times are GMT +1. The time now is 02:47 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"