B
BK
Using XP and Office 2003.
When I add, change, or delete information from my data worksheet, I know
that I can just click "refresh" on my pivot table and all the changes are
picked up. However, that is not the case when I add a new row of
information at the bottom of the original data worksheet. Is there
something I can other than recreating the pivot table? Because the data in
the worksheet is alphabetized, it is sometimes necessary to add a new row
after the last row in the table and that's when refreshing the pivot table
doesn't work.
When I add, change, or delete information from my data worksheet, I know
that I can just click "refresh" on my pivot table and all the changes are
picked up. However, that is not the case when I add a new row of
information at the bottom of the original data worksheet. Is there
something I can other than recreating the pivot table? Because the data in
the worksheet is alphabetized, it is sometimes necessary to add a new row
after the last row in the table and that's when refreshing the pivot table
doesn't work.