Excel Freezing when Pasting data consecutively

[KDavidP1987]

Greetings,

Context:


I have three tables (formatted as tables) with the same data going into them. Each table has different formulas for calculating different things. Duplicates from each table are removed differently, to accommodate different reports, which is why there are three (in case you were curious).


The data in them comes from a ticketing system that generates a csv file of the raw data (3K - 17K rows, depending on timeframe specified [monthly/weekly]).


When I go to copy and paste the data (unformatted, of course) into these three tables Excel freezes on the second and third table for about 5 min just to complete the paste action. The first data paste (tested with 17K rows data set) goes in within matter of seconds (like, 3 - 5). But consecutive pastes into the other tables freeze excel for minutes.

It doesn't matter what order I paste in (to which table)! The first paste is quickly entered, and the next two each freeze the program for significant time.

Question


Is there any way to speed this up?

 

[mole999]

is that from vba, are there formulas that have to update

 

[KDavidP1987]

It does so when pasted manually AND when pasted from VBA (with screen updating disabled)! There are formulas on each page that update. What gets me though, the first paste goes in super fast (seconds), no matter which page I choose to do first. It's always the second and third pastes that suddenly freeze Excel for 5 minutes

 

[mole999]

2nd and third will force the first to update again (I would suggest)

 

[KDavidP1987]

2nd and third will force the first to update again (I would suggest)

I appreciate you following up, but I'm sorry I don't understand... Is this an explanation or solution you posted? Is there a way to paste the data consecutively without it freezing for so long on the second and third paste?

 

[mole999]

done from VBA, or even the menu bar turn off calculation, until all pasted, then turn it back on and calculate. (If its the cause)

 

[KDavidP1987]

Thank you for the follow-up. Mole999! I am going to try that and see how well it works. I found the scripts necessary for turning off calculations on another site.

I'll just have to figure out the scripts necessary to fill down and calculate the formulas on those formatted tables afterwards.

You sir, are a gentleman and a scholar!

Sincerely,
Kris