Adding new lines to the same table RRS feed

  • Question

  • I have been adding weekly sales data to a master sheet and created a pivot table from that. Recently I have hit the maximum allowed amount of rows. I was told that PowerPivot has a much higher maximum so I created a table in the data model but I cannot seem to add new data to the model without creating an entirely new sheet in the model when I just want to keep adding to the same sheet. 

    Any help you could provide would be much appreciated. 
    Thursday, October 18, 2018 8:10 PM

All replies

  • PowerPivot can easily store tens of millions of records, but it stores the data internally. It does not change the maximum number of rows in an Excel sheet.

    I would guess that you are not hand typing 1 million rows into Excel - if you are getting this data from a database or an extract from a database the best thing to do is to connect PowerPivot directly to that data source and pull the data from there.

    http://darren.gosbell.com - please mark correct answers

    Friday, October 19, 2018 1:24 AM