 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008Excel Lags When Keying Numeric
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. Hi You could try setting Tools>Options>Calculation>manual and see if that helps. Press F9 when you want to calculate.  SignatureRegards Roger Govier > Happens on 2 files about 300KB - multiple worksheets (5-20) - simple > formula [quoted text clipped - 5 lines] > problems encountered. I would like advise aside from cutting and pasting > worksheets to another workbook. 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. > Hi > [quoted text clipped - 11 lines] > > problems encountered. I would like advise aside from cutting and pasting > > worksheets to another workbook. Hi Then for XL2007 try Round Office button>Excel Options>Formulas>Calculation options>manual>OK or, more easily, select the Formulas tab>click the small arrow on Calculation options>Manual To Force a calculation when in manual mode, either F9 or click the calculator icon to the right of the Calculator options. SignatureRegards Roger Govier > 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 [quoted text clipped - 20 lines] >> > pasting >> > worksheets to another workbook. 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. > Hi > [quoted text clipped - 29 lines] > >> > pasting > >> > worksheets to another workbook. 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 SignatureRegards Roger Govier > Thanks for you response Roger. But unfortunately I am still having the > same [quoted text clipped - 38 lines] >> >> > pasting >> >> > worksheets to another workbook. File sent to you. Thanks again for helping out. > Hi > [quoted text clipped - 46 lines] > >> >> > pasting > >> >> > worksheets to another workbook. 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. SignatureRegards Roger Govier > File sent to you. Thanks again for helping out. > [quoted text clipped - 54 lines] >> >> >> > pasting >> >> >> > worksheets to another workbook. Thanks Roger. This resolve the problem. > Hi > [quoted text clipped - 65 lines] > >> >> >> > pasting > >> >> >> > worksheets to another workbook. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.