Forum Discussion
Excel Sheet Reporting Getting to Maximum
Hello,
I am currently doing Excel Reporting in Reporting service. Currently I have 108k records and it will get to the max 150k.
What will happen to additional records when it get to maximum 150k?
I know in .xls format when the record gets to 65k, a new sheet starts with 6501 row.
So in .Xlsx what will hapen when it gets to 150k?
M_nwadibia wrote:
I know in .xls format when the record gets to 65k, a new sheet starts with 6501 row.
Are you sure it does this? I was pretty sure it just stopped at 65000 rows.
M_nwadibia wrote:
So in .Xlsx what will hapen when it gets to 150k?
It just keeps going, the xlsx format can hold upto 1 million rows in a single sheet.
Thank you. My excel record just exceeded 150k records and it is still going. This confirms it can go up to one million
2 Replies
M_nwadibia wrote:
I know in .xls format when the record gets to 65k, a new sheet starts with 6501 row.
Are you sure it does this? I was pretty sure it just stopped at 65000 rows.
M_nwadibia wrote:
So in .Xlsx what will hapen when it gets to 150k?
It just keeps going, the xlsx format can hold upto 1 million rows in a single sheet.
Thank you. My excel record just exceeded 150k records and it is still going. This confirms it can go up to one million