How do I change the overall size of a spreadsheet?

[MnSCU Dale]

I am trying to import some data into a spreadsheet. I have almost 130,000
lines of data. Is it possible to change the number of rows allowed in Excel?

[Fredrik Wahlgren]

"MnSCU Dale" <MnSCU [email protected]> wrote in message
news:[email protected]...
> I am trying to import some data into a spreadsheet. I have almost 130,000
> lines of data. Is it possible to change the number of rows allowed in
Excel?

No. You have to split your import so that it goes to two sheets.

/Fredrik

[Gord Dibben]

No.

Spread the data over two or more sheets.

Easiest way to do that is to import just part of the data on each import.

Can you import first to a text file then break that into smaller chunks?


Gord Dibben Excel MVP

On Tue, 12 Apr 2005 12:32:02 -0700, "MnSCU Dale" <MnSCU
[email protected]> wrote:

>I am trying to import some data into a spreadsheet. I have almost 130,000
>lines of data. Is it possible to change the number of rows allowed in Excel?