Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Enter info in one sheet, auto enter in another based on one field | New Users to Excel | |||
Slow Spread Sheet | Excel Worksheet Functions | |||
Why is my Excel 2002 slow to enter cell? | Excel Worksheet Functions | |||
My excel sheet is slow to changes. | Excel Discussion (Misc queries) | |||
enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) |