Excel Sheet Reporting Getting to Maximum

[M_nwadibia]

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?

[d_gosbell · Accepted solution]

---

@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.

[M_nwadibia · Accepted solution]

Thank you. My excel record just exceeded 150k records and it is still going. This confirms it can go up to one million

[d_gosbell · Accepted solution]

---

@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.