how to save large data sets in excel

[Guest]

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]

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

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