Forum Discussion

Jackie0090's avatar
Jackie0090
Copper Contributor
Dec 14, 2024

Excel crashing when Copying many cells as Values to another Excel file

Hi everyone!

I am working on a large Excel file that has a sheet with aprox 43k rows and column B with VLOOKUP formula, and column C with INDEX formulas:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I am trying to copy the values from column A, B and C up to row 43,792 and paste them in a new separate file as Values only.

But when i do this, it does not do it, it keeps crashing and looks to be "working" in background seeing the CPU super high:

While it's crashing, I can see the PC slowing down and being un-responsive.

I am on Win10 22H2, I got a powerful CPU and 64GB RAM, so I don't think the issue is the PC itself.

If anyone has come across an issue like this, I'd appreciate the advice on what to do!

PS: my only other solution on this is scriping it with Python to grab the data from the Excel file, but I don't wanna do this every single time I am using Excel files that are large and might have different columns.

Thank you!

excel
office 365
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Dec 25, 2024

    Use Ctrl + C to copy.

    Use Ctrl + Alt + V (Paste Special) > Values to replace the formulas with their results in the same file. This reduces the load during copying.

    Select a smaller range, e.g., 1,000 rows at a time.

     

    I hope that I was able to help you with your plans.

Resources