how to save large data sets in excel
 

I keep getting an error stating that "not all data saved". I know that I am
exceeding the 65k or so row limit, but, would like to know if there's any
way around this problem

From your question I presume that you are importing data to a Worksheet
and are achieving only the first 65,536 lines.
You will need then to visit your input source and separate the
remaining data from that you have managed to save.

If your data is a .csv file you could try opening it it Notepad (or
other similar editor), delete from the first line to the last line
already saved, then save the remaining data into a file to be imported
into a second worksheet.
(an overlap of say 10 lines could be useful if you wish to put headers
onto the first worksheet).



sheck Wrote:
I keep getting an error stating that "not all data saved". I know that
I am
exceeding the 65k or so row limit, but, would like to know if there's
any
way around this problem


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=391998