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: ...
Perhaps there is an issue with the file in question. Can you open a blank workbook and use a formula pointing to the range in question and then copy/paste special values that formula range?
i think u have a point. Both formulas VLOOKUP and INDEX i am using Columns as specified range , i.e. E:E from a different sheet.
I am gonna try to use specific range like $E$1:$E:$10 for instance.thx!
