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).

Originally Posted by sheck

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