Share via

Update Pivot Table To Recognize New Rows

Rich Locus 1 Reputation point
2021-01-10T20:50:39.617+00:00

Hello:
I have a Pivot Table to which I have added new rows. Even with a "Refresh All" the new rows are not added. How can I do this new row refresh?
Thanks,
Rich Locus

Microsoft 365 and Office | Excel | For business | Windows
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erin Ding-MSFT 4,496 Reputation points
    2021-01-11T10:19:22.007+00:00

    @Rich Locus

    Please check if the answer given by HansV-7609 is helpful to you.
    Any updates or questions, please let us know.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

  2. HansV 462.6K Reputation points
    2021-01-10T21:57:35.287+00:00

    The easiest way is to turn the source range into a table.
    Another option is to define a dynamic named range, and to use that as data source.
    See automatically-include-new-data-in-a-pivot-table

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.