Hello,

I have a data model in Excel with a couple dozen tabs, some of which have a couple million rows.

What I am trying to do it move a table with 5 million rows, lets call it "InvoiceTable", into 20 different tabs, named InvoiceTable-1, InvoiceTable-2, InvoiceTable-3, and so on, each with 250k rows. I need to split them because Excel gets cranky when you try to post 5M rows into one tab.

The way I think this will work is if I create a simple helper column in each table where row count will be an issue, something to the effect of =INT(ROW()/250000), and use that as the split-point and also as a value to concatenate onto the resulting tab names so there are no duplicate tabs.

My question is; how would I go about Exporting tabs of data in DataModel into Excel sheets, while splitting them by the value I create with the formula?


Thanks!