| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Lags When Keying Numeric
Thanks Roger. This resolve the problem.
"Roger Govier" wrote: Hi File received and does behave exactly as you say. copying the sheets to another workbook, the same problem exists. I cannot see any reason for this behaviour, therefore I think the file has somehow been corrupted. I wrote some VBA code to read all of the data and formulae across to another workbook, and all appears to be OK. I have mailed the new file back to you. -- Regards Roger Govier "ExcelUser" wrote in message ... File sent to you. Thanks again for helping out. "Roger Govier" wrote: Hi if you want to send me the file, I will take a look and see if I can see what is going wrong. To send direct, mail to roger at technology4u dot co dot uk Change the at and dots to make a valid email address -- Regards Roger Govier "ExcelUser" wrote in message ... Thanks for you response Roger. But unfortunately I am still having the same lagwhen I key numeric only. Even on cells when no formula, imply typng numbers from cel to cell lags. "Roger Govier" wrote: Hi Then for XL2007 try Round Office buttonExcel OptionsFormulasCalculation optionsmanualOK or, more easily, select the Formulas tabclick the small arrow on Calculation optionsManual To Force a calculation when in manual mode, either F9 or click the calculator icon to the right of the Calculator options. -- Regards Roger Govier "ExcelUser" wrote in message ... Sorry if I was not veru detail on my issue. I am using Office 2007. When I opened up the file and go to a blank column and start typing text on each row of the blank column - no problem exists. When I start typing digits on each cell of the blank column, it lags 15-20 seconds. Thanks for your reply. "Roger Govier" wrote: Hi You could try setting ToolsOptionsCalculationmanual and see if that helps. Press F9 when you want to calculate. -- Regards Roger Govier "ExcelUser" wrote in message ... Happens on 2 files about 300KB - multiple worksheets (5-20) - simple formula adding and dividing within the worksheet - no referencing to other worksheets or workbook. When I key in alphabet text no problems. When I key in numeric even 1 digit, it lags 15-20 seconds. I opened a blank new worksheet no problems encountered. I would like advise aside from cutting and pasting worksheets to another workbook. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Over keying a formula - Can I set this to automatically bold ? | Excel Worksheet Functions | |||
| Is it possible to automatically change color of cell by keying off the date? | Excel Worksheet Functions | |||
| Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) | |||
| Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
| Send to Mail Recipient (as attachment) Lags | Excel Discussion (Misc queries) | |||
Threaded Mode
