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.