New
#1
Problem saving large excel files
I have 2 excel files, One file A is 18MB and the other B is 25MB.
I try to vlookup the data from A in B.
A has approx 96000 entries whereas B has 265000 entries.
The Vlookup function itself takes 12 minutes whereas at the time of file saving, excel gives the message "File not responding"
Can somebody help me with this.