ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I remove a delay on excel between cells (https://www.excelbanter.com/excel-discussion-misc-queries/226748-how-do-i-remove-delay-excel-between-cells.html)

Margaret

How do I remove a delay on excel between cells
 
when I paste in a cell in excel and then move to the next cell there is a 2
second delay. How do I get rid of the delay

Dave

How do I remove a delay on excel between cells
 
Hi Margaret,
My guess is that the sheet contains a lot of formulas, and the 2 seconds is
the time XL takes to re-calculate them all.
Lokk down at the bottom left corner of XL next time you paste, and see if it
says:
Calculating...
Regards - Dave.

"Margaret" wrote:

when I paste in a cell in excel and then move to the next cell there is a 2
second delay. How do I get rid of the delay


Bill Sharpe

How do I remove a delay on excel between cells
 
Dave wrote:
Hi Margaret,
My guess is that the sheet contains a lot of formulas, and the 2 seconds is
the time XL takes to re-calculate them all.
Lokk down at the bottom left corner of XL next time you paste, and see if it
says:
Calculating...
Regards - Dave.

"Margaret" wrote:

when I paste in a cell in excel and then move to the next cell there is a 2
second delay. How do I get rid of the delay

You can turn off automatic calculating, but be sure to turn it back on
or calculate manually before you print or quit the program.

Bill


All times are GMT +1. The time now is 11:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com