Spark

I have not yet installed the beta version of Office 2007.

There are many regulars in these groups that have.

Hopefully one of them will leap in and address your concern.

But, with versions up to now you could install just the components desired.

Best to wait for more help.


Gord

On Thu, 27 Jul 2006 17:46:20 -0700, Bright Spark
wrote:

Thanks, Gord.

In one of the instruction sets I read, it said "If your worksheet
contains more than 65,536 but fewer than 98,304 rows, use the Text
Import Wizard to import the text file into multiple worksheets" -
that's where I got the 98,304 from, but I realize now when I look at
it that it still needs to go into multiple worksheets.

Is there any way to use Excel 2007 without having to update/include MS
Word? I am so reluctant to do that because everything on my system
always goes haywire when I make any changes to MS Word and it takes me
weeks to put all my settings back together! <sigh

Thanks again.

Heather


On Thu, 27 Jul 2006 15:00:17 -0700, Gord Dibben <gorddibbATshawDOTca
wrote:

The limit per sheet is 65536 rows.

I don't know where the 98,304 came from.

For a VBA method of importing greater than 65536 rows over multiple sheets see

http://support.microsoft.com/default...;en-us;Q120596

NOTE: Excel 2007(beta) has one million rows per sheet.


Gord Dibben MS Excel MVP

On Thu, 27 Jul 2006 14:42:26 -0700, Bright Spark
wrote:

I have a mailing list in .txt format that I need to open in Excel in
order to clean up and sort, etc. The problem I am having is that the
list is 76,007 records long and Excel will not allow me to have that
many - I get the message "File not completely loaded" (or something
similar).

I have done some searching and I have discovered that only 65,536 rows
can be in one worksheet (that is exactly how many it will load) but
there does seem to be some way to increase that number as long as the
final number is below 98,304 rows.

I am a total "newbie" as far as Excel is concerned and purely
hunt-and-peck my way through using it, learning as I go, but I cannot
figure out how I can end up with my full 76,007 records in just one
worksheet?

I would appreciate some instruction on this if anyone can help or
point me in the right direction.

Thanks very much.

BrightSpark


Gord Dibben MS Excel MVP