S
Severino5
Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
I've started working a little bit with Pivot Tables and setting up some charts. However, I'm not sure how to optimally set up a Pivot Table so that I can add new rows / new data.
If I have, say, 20 rows of data create the Pivot Table, and then add more rows below the original data, it won't reflect the new rows. The only way I see to adjust the selection range is to go into the Pivot Table Wizard.
I did try a config where I selected the whole column, but the updates take forever.
Any suggestions on a better setup or method? Thanks!
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
I've started working a little bit with Pivot Tables and setting up some charts. However, I'm not sure how to optimally set up a Pivot Table so that I can add new rows / new data.
If I have, say, 20 rows of data create the Pivot Table, and then add more rows below the original data, it won't reflect the new rows. The only way I see to adjust the selection range is to go into the Pivot Table Wizard.
I did try a config where I selected the whole column, but the updates take forever.
Any suggestions on a better setup or method? Thanks!