|
|
| Next: Break link MS Excel 2000 |
| Author |
Message |
Lauren
External
Since: Nov 11, 2004
Posts: 38
|
 Posted: Thu Sep 15, 2005 1:01 pm Post subject: Is it possible to have more than 65,336 lines in one sheet?
Archived from groups: microsoft>public>excel>misc (more info?) |
|
|
|
| Is it possible to have more than 65,336 lines in one sheet?
I have data to import that has 1,000,000 lines, is it possible to view in
one spreadsheet?
|
|
|
| Back to top |
|
 |
David Billigmeier
External
Since: Sep 12, 2005
Posts: 331
|
Posted: Thu Sep 15, 2005 1:06 pm Post subject: RE: Is it possible to have more than 65,336 lines in one she [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?) |
|
|
No, unfortunatelly not. Try importing your data into Access then querying it
from Excel.... Data->Import External Data->New Database Query.
--
Regards,
Dave
<!--
"Lauren" wrote:
> Is it possible to have more than 65,336 lines in one sheet?
>
> I have data to import that has 1,000,000 lines, is it possible to view in
> one spreadsheet? |
|
| Back to top |
|
|
Alan
External
Since: Nov 22, 2003
Posts: 481
|
Posted: Thu Sep 15, 2005 9:08 pm Post subject: Re: Is it possible to have more than 65,336 lines in one she [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?) |
|
|
Afraid not, 256 columns and 65,536 rows are written in stone,
Regards,
Alan.
"Lauren" <Lauren.TakeThisOut@discussions.microsoft.com> wrote in message
news:EA2FFE48-51B2-425E-8156-8046FC401703@microsoft.com...
> Is it possible to have more than 65,336 lines in one sheet?
>
> I have data to import that has 1,000,000 lines, is it possible to view in
> one spreadsheet? |
|
| Back to top |
|
|
Ron de Bruin
External
Since: Sep 26, 2003
Posts: 2026
|
Posted: Thu Sep 15, 2005 10:07 pm Post subject: Re: Is it possible to have more than 65,336 lines in one she [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?) |
|
|
No
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Lauren" <Lauren DeleteThis @discussions.microsoft.com> wrote in message news:EA2FFE48-51B2-425E-8156-8046FC401703@microsoft.com...
> Is it possible to have more than 65,336 lines in one sheet?
>
> I have data to import that has 1,000,000 lines, is it possible to view in
> one spreadsheet? |
|
| Back to top |
|
|
Stephen Jame Pattenden
External
Since: Jan 03, 2007
Posts: 3
|
Posted: Fri Jan 05, 2007 8:56 am Post subject: RE: Is it possible to have more than 65,336 lines in one sheet? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?) |
|
|
I have heard that Excel 2007 will allow more; it will only be limited by your
system memory. Don't hold me to it but it was in one of my pc magazines a
while back...
"Lauren" wrote:
> Is it possible to have more than 65,336 lines in one sheet?
>
> I have data to import that has 1,000,000 lines, is it possible to view in
> one spreadsheet? |
|
| Back to top |
|
|
Bernard Liengme
External
Since: Jan 27, 2004
Posts: 2596
|
Posted: Fri Jan 05, 2007 1:28 pm Post subject: Re: Is it possible to have more than 65,336 lines in one sheet? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?) |
|
|
Excel 2007 has - are your ready for this? - 1 millions rows
Oh what scope for misuse!!!
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Stephen Jame Pattenden" <StephenJamePattenden RemoveThis @discussions.microsoft.com>
wrote in message news:23DC5133-3540-4F8E-88B9-F7AD2E24F835@microsoft.com...
>I have heard that Excel 2007 will allow more; it will only be limited by
>your
> system memory. Don't hold me to it but it was in one of my pc magazines a
> while back...
>
> "Lauren" wrote:
>
>> Is it possible to have more than 65,336 lines in one sheet?
>>
>> I have data to import that has 1,000,000 lines, is it possible to view in
>> one spreadsheet? |
|
| Back to top |
|
|
|
|
|
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
| |
|
|
Microsoft Office