Excel 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.

Excel Lags When Keying Numeric
 

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.

Excel Lags When Keying Numeric
 

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.

Excel Lags When Keying Numeric
 

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.

Excel Lags When Keying Numeric
 

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.

Excel Lags When Keying Numeric
 

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.

Excel Lags When Keying Numeric
 

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.

Excel Lags When Keying Numeric
 

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.

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.