Problem saving large excel files


  1. raisathya
    Posts : 1
    Windiws 8.1
       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.
      My Computer
    Quote Quote

  3. strollin
    Posts : 3,371
    W10 Pro desktop, W11 laptop, W11 Pro tablet (all 64-bit)
       New #2

    It might be time to move to a real database then instead of using Excel. How about using Access or MySQL instead?

    Are you at least using 64-bit Excel?
      My Computer
    Quote Quote

  4. Ranger4
    Posts : 9,746
    Windows 7 Home Premium 64 bit sp1
       New #3

    AS well as the suggestion by strollin in Post #2, your computer may have not have enough RAM or has other limits on it's capacity. Your System Specs are very vague & we can't see any details about your computer set up.
      My Computer
    Quote Quote

 

  Related Discussions
The “problem” I’m concerned about is that I noticed existingExcel 2007 xlsx files are now saving with fewer Kb. I have a Lenovo W700ds and a W541. Both computers are running Windows 7 Pro 64bit. The W700 has Office 2007 and theW541 has Office 2013. Both versions ofExcel are 32 bit as far as I...
Hello, I have a very rare issue here. I'm trying to convert a normal xlsx file into a csv file. In the xlsx file there are normal columns and rows, nothing strange, nor formatting or something pretty, only colums and rows with products plain information. I've received these files via...
I have a problem in saving an excel file on to another pc in the network, which has windows xp. But before I used in both pc’s windows xp & that time there were no problem saving on to the other pc. Now I use windows 7 32bit (Service pack1) in my pc & other pc on network is windows xp. Im doing...
Hello, Im getting random BSOD while saving large attachements in outlook. Error code 0x0000007a , details in jpg file. Ive tried few things like: - make more empty space - uninstalling some antiviral software - installing updates for win and office - disable automatic updates - chkdsk /f...
I have an new style Excel xlsx spreadsheet that I received from a customer through Email and I can open and re-save as an xlsx spreadsheet using excel 2010. I have saved it to my desktop. When I try to save it in the 97-2003 xls format. Excel then crashes right away and a window pops up. Microsoft...
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 09:42.
Find Us