Share via

Pivot table shrinks data source when refresh

Anonymous
2024-09-10T17:50:10+00:00

I have a pivot table from a source that goes to row 5000. Sometimes, the source doesn't have data for all 5000 rows, and when I refresh the pivot table, its range changes automatically to row 200.

How can I avoid the data source range being modified?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2024-09-11T02:35:40+00:00

How I can I reproduce your issue? It doesn't change at my side.

You may try use Entire column as data source.

'Data base'!$A:$D

Or Format your data as a table. When new rows are added to your table, it will be included in your povittable.

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-09-11T16:14:23+00:00

    Thanks Snow Lu! Using the entire columns on the data source worked perfectly.

    Was this answer helpful?

    0 comments