Can't view my published app

[Jeff_Hager]

Data not taking all row of my Pivot Table in my Google sheet

Likely you have exceed the row limit for your plan. Why would you have to update anything manually? Query and Rollup columns are dynamic based on the input data.