Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Problem saving large excel files

03 May 2017   #1
raisathya

Windiws 8.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 System SpecsSystem Spec
.
03 May 2017   #2
strollin

W10 Pro desktop, W10 laptop, W10 laptop, W10 Pro tablet (all 64-bit)
 
 

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 System SpecsSystem Spec
03 May 2017   #3
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

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 System SpecsSystem Spec
.

Reply

 Problem saving large excel files




Thread Tools




Similar help and support threads
Thread Forum
Excel 2007 Files Are Now Saving with Fewer KB in Both Excel 2007 and 2
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...
Microsoft Office
Excel 2013 - Processor overheats when processing large files
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...
Microsoft Office
Excel file saving problem in the network
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...
Network & Sharing
BSOD While saving large files in outlook
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...
BSOD Help and Support
problem saving excel spread sheet in 2010 to 97-2003 format
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...
Microsoft Office


Our Sites

Site Links

About Us

Find 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 03:54.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App