Excel Lags When Keying Numeric

[ExcelUser]

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.

 

[Roger Govier]

Hi

You could try setting Tools>Options>Calculation>manual
and see if that helps.
Press F9 when you want to calculate.

 

[ExcelUser]

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

 

[Roger Govier]

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.

 

[ExcelUser]

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]

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

 

[ExcelUser]

File sent to you. Thanks again for helping out.

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

 

[Roger Govier]

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.

 

[ExcelUser]

Thanks Roger. This resolve the problem.

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.