Downloaded Excel file taking long time to open
Its a simple concern -
I have downloaded the bigger data from "(any CRM application)" which is in *.xls format but taking longer time to open in Excel.
Can someone help me how I can open the file without time consuming.
Data has 60,000 rows and 28 columns.
Note: unable to attach the data cause of bigger size.
Re: Downloaded Excel file taking long time to open
Ram size is matters, to open large files.....
If u open the sheet then split the large file into halves. Put a half each on sheet 1 and sheet 2. Link any totalling or analysing cells to sheet 3, and summarise sheet 3 if required. Hopefully, someone will provide a better answer.
might be to split the large file into halves.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By harshrajpurohit in forum Excel Programming / VBA / Macros
Last Post: 02-25-2013, 06:19 AM
By MikeWard100 in forum Excel General
Last Post: 02-14-2013, 09:57 AM
By narendrabr in forum Excel General
Last Post: 10-17-2012, 03:11 AM
By clowrym in forum Excel General
Last Post: 05-29-2009, 01:14 PM
By dkblee in forum Excel General
Last Post: 03-26-2006, 06:35 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1