Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel could not save all the data and formatting you recently ad.. | Excel Worksheet Functions | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Fetching External Data from Excel | Excel Discussion (Misc queries) |