LARGE dataset

[jrh in school]

How do I open a dataset that is larger than the 65,000+
worksheet limit. So far, it does not open on more than
one worksheet, rather it just cuts off my dataset at the
65,000+ limit.

 

[David McRitchie]

65536 rows is a specification limit in Excel you cannot have
more rows in a spreadsheet. There are various webpages that
give you some alternatives.

Q120596 -- XL: Importing Text Files Larger Than 16384 Rows
Breaks files longer than sheet limit into more sheets.
(Also covers Microsoft Excel 97 and up which have a limit of 65,536 rows)
http://support.microsoft.com/default.aspx?scid=kb;en-us;q120596

Please post to only one newsgroup rather than waste the time
of people who can make much better use of their time by not answering
questions that might be answered in another place as well.