Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
wise_man
 
Posts: n/a
Default The increase number of rows in Excel

I'm working in Telecom industry, where I'm using Excel almost 90% of my
duties, I am facing the problem when I want to transport the information
from the billing system to Excel, I am talking about 1,000,000 + entries
(rows), where excel it only have 65,000 rows, it is very difficult to split
the data into different sheet, it is also a time consume to run the quiry in
the billing by considering the limitation of excel, to carry all the rows
extracted from billing. i.e. I f i want the data from 1st to 31st, then I
have split them in 3 group ( ten days each) I would suggest to increase
number of rows atleast to 2,000,000 rows. in addition to that CDR extracted
from billing system contains more then 2,000,0000 entries.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc
  #2   Report Post  
Posted to microsoft.public.excel.misc
Franz Verga
 
Posts: n/a
Default The increase number of rows in Excel

Excel 2007 will have 1.048.576 rows.

For now I can suggest you to import your data in MS Access and then from
Access you can export to Excel the summary you need

Nel post
*wise_man* ha scritto:

I'm working in Telecom industry, where I'm using Excel almost 90% of
my duties, I am facing the problem when I want to transport the
information from the billing system to Excel, I am talking about
1,000,000 + entries (rows), where excel it only have 65,000 rows, it
is very difficult to split the data into different sheet, it is also
a time consume to run the quiry in the billing by considering the
limitation of excel, to carry all the rows extracted from billing.
i.e. I f i want the data from 1st to 31st, then I have split them in
3 group ( ten days each) I would suggest to increase number of rows
atleast to 2,000,000 rows. in addition to that CDR extracted from
billing system contains more then 2,000,0000 entries.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click
the "I Agree" button in the message pane. If you do not see the
button, follow this link to open the suggestion in the Microsoft
Web-based Newsreader and then click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy


  #3   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier
 
Posts: n/a
Default The increase number of rows in Excel

And how long did we all think it would be before someone asked for the
new limit of 1 million rows in Excel 2007 to be increased<vbg

wise_man the new version of Excel has had the limits increased to 1
million rows and 16,000 columns.
At present it is not released as a final product, but is available as a
Beta download from the Microsoft website.
Maybe you could try it out to see if it is of help to you, but be aware
that it is still a BETA version.

--
Regards

Roger Govier


"wise_man" wrote in message
...
I'm working in Telecom industry, where I'm using Excel almost 90% of
my
duties, I am facing the problem when I want to transport the
information
from the billing system to Excel, I am talking about 1,000,000 +
entries
(rows), where excel it only have 65,000 rows, it is very difficult to
split
the data into different sheet, it is also a time consume to run the
quiry in
the billing by considering the limitation of excel, to carry all the
rows
extracted from billing. i.e. I f i want the data from 1st to 31st,
then I
have split them in 3 group ( ten days each) I would suggest to
increase
number of rows atleast to 2,000,000 rows. in addition to that CDR
extracted
from billing system contains more then 2,000,0000 entries.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click
the "I
Agree" button in the message pane. If you do not see the button,
follow this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,173
Default The increase number of rows in Excel

Roger

It was inevitable, what worries me is that with 65,000 rows and 256 columns,
any SUMIFs, VLOOKUPs, etc grind the workbook to a halt. Granted, XL2007 has
a new multi-threaded calculation engine, which will help, but that much data
just shouldn't be in Excel, it's highly inefficient and cries out for a
normalised database, with Excel as a front-end to do the summary reporting.

In my eyes, we will come to regret the bigger grid!

My £0.02

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Roger Govier" wrote in message
...
And how long did we all think it would be before someone asked for the new
limit of 1 million rows in Excel 2007 to be increased<vbg

wise_man the new version of Excel has had the limits increased to 1
million rows and 16,000 columns.
At present it is not released as a final product, but is available as a
Beta download from the Microsoft website.
Maybe you could try it out to see if it is of help to you, but be aware
that it is still a BETA version.

--
Regards

Roger Govier


"wise_man" wrote in message
...
I'm working in Telecom industry, where I'm using Excel almost 90% of my
duties, I am facing the problem when I want to transport the information
from the billing system to Excel, I am talking about 1,000,000 + entries
(rows), where excel it only have 65,000 rows, it is very difficult to
split
the data into different sheet, it is also a time consume to run the quiry
in
the billing by considering the limitation of excel, to carry all the rows
extracted from billing. i.e. I f i want the data from 1st to 31st, then I
have split them in 3 group ( ten days each) I would suggest to increase
number of rows atleast to 2,000,000 rows. in addition to that CDR
extracted
from billing system contains more then 2,000,0000 entries.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc




  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,886
Default The increase number of rows in Excel

Hi Nick

I quite agree.
It was perhaps foolish of me not to point out in my post that a database
solution would be far preferable.

I still haven't loaded my copy of XL2007 yet to even look at what a
calculation on a single column of 1m rows behaves like - just for the
hell of it, not because I would contemplate using it in this way.

--
Regards

Roger Govier


"Nick Hodge" wrote in message
...
Roger

It was inevitable, what worries me is that with 65,000 rows and 256
columns, any SUMIFs, VLOOKUPs, etc grind the workbook to a halt.
Granted, XL2007 has a new multi-threaded calculation engine, which
will help, but that much data just shouldn't be in Excel, it's highly
inefficient and cries out for a normalised database, with Excel as a
front-end to do the summary reporting.

In my eyes, we will come to regret the bigger grid!

My £0.02

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Roger Govier" wrote in message
...
And how long did we all think it would be before someone asked for
the new limit of 1 million rows in Excel 2007 to be increased<vbg

wise_man the new version of Excel has had the limits increased to 1
million rows and 16,000 columns.
At present it is not released as a final product, but is available as
a Beta download from the Microsoft website.
Maybe you could try it out to see if it is of help to you, but be
aware that it is still a BETA version.

--
Regards

Roger Govier


"wise_man" wrote in message
...
I'm working in Telecom industry, where I'm using Excel almost 90% of
my
duties, I am facing the problem when I want to transport the
information
from the billing system to Excel, I am talking about 1,000,000 +
entries
(rows), where excel it only have 65,000 rows, it is very difficult
to split
the data into different sheet, it is also a time consume to run the
quiry in
the billing by considering the limitation of excel, to carry all the
rows
extracted from billing. i.e. I f i want the data from 1st to 31st,
then I
have split them in 3 group ( ten days each) I would suggest to
increase
number of rows atleast to 2,000,000 rows. in addition to that CDR
extracted
from billing system contains more then 2,000,0000 entries.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to
the
suggestions with the most votes. To vote for this suggestion, click
the "I
Agree" button in the message pane. If you do not see the button,
follow this
link to open the suggestion in the Microsoft Web-based Newsreader
and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc








  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,173
Default The increase number of rows in Excel

We have a workbook at work that takes about 30 seconds to calculate in 2003
and about 20seconds in 2007, which is great, but this is inter-worksheet
linking and not at all using a lot of rows and columns.

There's a huge difference between 16777216 cells (972003) and 17179869184
cells (2007). I'm not even sure if you can enter a 1 in each without hitting
the memory limit...off to try!

3 minutes so far and showing as (not responding)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Roger Govier" wrote in message
...
Hi Nick

I quite agree.
It was perhaps foolish of me not to point out in my post that a database
solution would be far preferable.

I still haven't loaded my copy of XL2007 yet to even look at what a
calculation on a single column of 1m rows behaves like - just for the hell
of it, not because I would contemplate using it in this way.

--
Regards

Roger Govier


"Nick Hodge" wrote in message
...
Roger

It was inevitable, what worries me is that with 65,000 rows and 256
columns, any SUMIFs, VLOOKUPs, etc grind the workbook to a halt. Granted,
XL2007 has a new multi-threaded calculation engine, which will help, but
that much data just shouldn't be in Excel, it's highly inefficient and
cries out for a normalised database, with Excel as a front-end to do the
summary reporting.

In my eyes, we will come to regret the bigger grid!

My £0.02

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Roger Govier" wrote in message
...
And how long did we all think it would be before someone asked for the
new limit of 1 million rows in Excel 2007 to be increased<vbg

wise_man the new version of Excel has had the limits increased to 1
million rows and 16,000 columns.
At present it is not released as a final product, but is available as a
Beta download from the Microsoft website.
Maybe you could try it out to see if it is of help to you, but be aware
that it is still a BETA version.

--
Regards

Roger Govier


"wise_man" wrote in message
...
I'm working in Telecom industry, where I'm using Excel almost 90% of my
duties, I am facing the problem when I want to transport the
information
from the billing system to Excel, I am talking about 1,000,000 +
entries
(rows), where excel it only have 65,000 rows, it is very difficult to
split
the data into different sheet, it is also a time consume to run the
quiry in
the billing by considering the limitation of excel, to carry all the
rows
extracted from billing. i.e. I f i want the data from 1st to 31st, then
I
have split them in 3 group ( ten days each) I would suggest to increase
number of rows atleast to 2,000,000 rows. in addition to that CDR
extracted
from billing system contains more then 2,000,0000 entries.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc








  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default The increase number of rows in Excel

Roger,

here comes again, I have a file with more then 65,536 rows, which is not
capable in fitting to one worksheet, is excel can manage automaticaly to open
it or split into different worksheet in one workbook.

"Roger Govier" wrote:

And how long did we all think it would be before someone asked for the
new limit of 1 million rows in Excel 2007 to be increased<vbg

wise_man the new version of Excel has had the limits increased to 1
million rows and 16,000 columns.
At present it is not released as a final product, but is available as a
Beta download from the Microsoft website.
Maybe you could try it out to see if it is of help to you, but be aware
that it is still a BETA version.

--
Regards

Roger Govier


"wise_man" wrote in message
...
I'm working in Telecom industry, where I'm using Excel almost 90% of
my
duties, I am facing the problem when I want to transport the
information
from the billing system to Excel, I am talking about 1,000,000 +
entries
(rows), where excel it only have 65,000 rows, it is very difficult to
split
the data into different sheet, it is also a time consume to run the
quiry in
the billing by considering the limitation of excel, to carry all the
rows
extracted from billing. i.e. I f i want the data from 1st to 31st,
then I
have split them in 3 group ( ten days each) I would suggest to
increase
number of rows atleast to 2,000,000 rows. in addition to that CDR
extracted
from billing system contains more then 2,000,0000 entries.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click
the "I
Agree" button in the message pane. If you do not see the button,
follow this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc




  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 459
Default The increase number of rows in Excel

Hi wise_man,

you can see he

http://support.microsoft.com/default...;EN-US;Q120596



--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy


  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default The increase number of rows in Excel

Dear Franz,

First thank you, it did work out, however i still have one propblem, the
text file exported to excel contains characters such as commas and tabs
separater, hence forth I also want the exportaion process to consider these
characters and split accordingly to different collums insted of all the
records posted to one column

I still seek for your assistance.

"Franz Verga" wrote:

Hi wise_man,

you can see he

http://support.microsoft.com/default...;EN-US;Q120596



--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy



  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 459
Default The increase number of rows in Excel

wise_man wrote:
"Franz Verga" wrote:

Hi wise_man,

you can see he

http://support.microsoft.com/default...;EN-US;Q120596



Dear Franz,

First thank you, it did work out, however i still have one propblem,
the text file exported to excel contains characters such as commas
and tabs separater, hence forth I also want the exportaion process to
consider these characters and split accordingly to different collums
insted of all the records posted to one column



You can use the Text to columns utility (menu Data, Text to columns) to
split your data. You could also use the Macro recorder (while using Text to
columns utility) to record a macro that split the imported data.


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy




  #11   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default The increase number of rows in Excel

Hi Franz,

Just a short note to forward my apreciation on your help, it did work out

Thank you.

"Franz Verga" wrote:

wise_man wrote:
"Franz Verga" wrote:

Hi wise_man,

you can see he

http://support.microsoft.com/default...;EN-US;Q120596



Dear Franz,

First thank you, it did work out, however i still have one propblem,
the text file exported to excel contains characters such as commas
and tabs separater, hence forth I also want the exportaion process to
consider these characters and split accordingly to different collums
insted of all the records posted to one column



You can use the Text to columns utility (menu Data, Text to columns) to
split your data. You could also use the Macro recorder (while using Text to
columns utility) to record a macro that split the imported data.


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy



  #12   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Formular

Dear Team,

I remember you help me out my keen questions few month back, which I really
apriaciate for that, but now I come with another question, I have two columns
one is containg Country Codes (one cell one contry code) and the other Column
containingg Dial codes, in which you can find too many dial codes in one
Cell, this is very dependable on its Country Numbering Plan. However all
dial codes are separated with commas. Consequently, my question is there any
formular I can use to take Contry codes from one Column and add infornt of
each Dial code in another Column that are separated by Commas??? It has been
difficult to me to use CONCATENATE since there is too many Dial codes in one
Cell and all are separated with Commas. What I'm doing Currently is adding
mannually, which the task has become tidious and time consume.

thank you in adavance for your help.

"Franz Verga" wrote:

Excel 2007 will have 1.048.576 rows.

For now I can suggest you to import your data in MS Access and then from
Access you can export to Excel the summary you need

Nel post
*wise_man* ha scritto:

I'm working in Telecom industry, where I'm using Excel almost 90% of
my duties, I am facing the problem when I want to transport the
information from the billing system to Excel, I am talking about
1,000,000 + entries (rows), where excel it only have 65,000 rows, it
is very difficult to split the data into different sheet, it is also
a time consume to run the quiry in the billing by considering the
limitation of excel, to carry all the rows extracted from billing.
i.e. I f i want the data from 1st to 31st, then I have split them in
3 group ( ten days each) I would suggest to increase number of rows
atleast to 2,000,000 rows. in addition to that CDR extracted from
billing system contains more then 2,000,0000 entries.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click
the "I Agree" button in the message pane. If you do not see the
button, follow this link to open the suggestion in the Microsoft
Web-based Newsreader and then click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy



  #13   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Formular

If the country code is in A1 and the comma-separated dialling codes in B1,
then
=A1&SUBSTITUTE(B1,",",","&A1)
in C1 will do what you ask. E.g. if A1 contains 49 and B1 211,221,228,30,69
, then C1 will display 49211,49221,49228,4930,4969. Be careful about your
thousand separators.

--
Noel

"wise_man" wrote in message
...
Dear Team,

I remember you help me out my keen questions few month back, which I
really
apriaciate for that, but now I come with another question, I have two
columns
one is containg Country Codes (one cell one contry code) and the other
Column
containingg Dial codes, in which you can find too many dial codes in one
Cell, this is very dependable on its Country Numbering Plan. However all
dial codes are separated with commas. Consequently, my question is there
any
formular I can use to take Contry codes from one Column and add infornt of
each Dial code in another Column that are separated by Commas??? It has
been
difficult to me to use CONCATENATE since there is too many Dial codes in
one
Cell and all are separated with Commas. What I'm doing Currently is
adding
mannually, which the task has become tidious and time consume.

thank you in adavance for your help.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Rows & Columns in Excel seadragon69 Excel Worksheet Functions 2 December 7th 05 06:54 PM
convert text-format number to number in excel 2000%3f Larry Excel Discussion (Misc queries) 1 July 29th 05 08:18 PM
Insert rows Mr. G. Excel Worksheet Functions 3 March 31st 05 03:49 AM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 12:32 PM


All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"