Forum Discussion
Excel crashing when copying large number of cells to another file
I'm not sure why Excel is crashing on that but here are a couple alternative ideas you could try to circumvent that:
a) copy then convert to values. Not sure if this would help at all but what if you copied the data first and then did a copy and paste as values in the same file. To copy you can try a) copy-paste, b) copy sheet to new workbook (right click on tab and choose copy or move sheet), c) Save As the file
b) since you just want the value, do a Save As and save it as a CSV file and then open the CSV file in Excel (don't forget to save as an xlsx if you do any further manipulations)
I was thinking of this for b) i'd have that sheet as the first one to save as CSV, so then the CSV when it's saved it's using just that sheet. Everytime i save as CSV, it always saves the first sheet for me.
Regarding a) i tried but it also crashed, I'll try again.
Thank you!
by chance you don't have any volatile functions in those formulas do you? Like RAND() or INDIRECT(). And assuming you have Excel 365 you might consider using some of the newer functions that have been optimized better like XLOOKUP. Maybe you could share a small version of that workbook (with nothing personal/private) and we could see if there might be a better option.