ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Copy / Paste extremely slow (https://www.excelbanter.com/excel-worksheet-functions/139941-copy-paste-extremely-slow.html)

Isotope07

Copy / Paste extremely slow
 
Excel is pausing for a very long time during copy/paste. It takes 10+ seconds
to copy a single cell (text only), and another 10+ to paste. It is as if
Excel (or another program) is performing another task in between. Thoughts?

Barb Reinhardt

Copy / Paste extremely slow
 
It could be recalculating. Set the calculation to MANUAL to see.

Tools - Options - Calculation - MANUAL

"Isotope07" wrote:

Excel is pausing for a very long time during copy/paste. It takes 10+ seconds
to copy a single cell (text only), and another 10+ to paste. It is as if
Excel (or another program) is performing another task in between. Thoughts?


Isotope07

Copy / Paste extremely slow
 
Thanks for the response - unfortunately, there are no formulas in the
spreadsheet, and no other spreadsheets open...

"Isotope07" wrote:

Excel is pausing for a very long time during copy/paste. It takes 10+ seconds
to copy a single cell (text only), and another 10+ to paste. It is as if
Excel (or another program) is performing another task in between. Thoughts?


Barb Reinhardt

Copy / Paste extremely slow
 
What's the source of the data? Internet?

"Isotope07" wrote:

Thanks for the response - unfortunately, there are no formulas in the
spreadsheet, and no other spreadsheets open...

"Isotope07" wrote:

Excel is pausing for a very long time during copy/paste. It takes 10+ seconds
to copy a single cell (text only), and another 10+ to paste. It is as if
Excel (or another program) is performing another task in between. Thoughts?


Isotope07

Copy / Paste extremely slow
 
It is a CSV from Quicken - I downloaded an Office update this morning which
appears to have solved the problem.


"Barb Reinhardt" wrote:

What's the source of the data? Internet?

"Isotope07" wrote:

Thanks for the response - unfortunately, there are no formulas in the
spreadsheet, and no other spreadsheets open...

"Isotope07" wrote:

Excel is pausing for a very long time during copy/paste. It takes 10+ seconds
to copy a single cell (text only), and another 10+ to paste. It is as if
Excel (or another program) is performing another task in between. Thoughts?



All times are GMT +1. The time now is 12:49 PM.

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