Forum Discussion
Excel crashing when copying large number of cells to another file
Hi everyone I have an Excel file that has a sheet with about 43k rows, and each have a VLOOKUP formula in Column B and INDEX formula in column C: ...
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.