How do I add extra data to a pivot table?

I know this might sound slightly simplistic, but my pivot table pulls data
from a separate tab. I know if I go in and amend the data in that table and
then save and restart, the data in my pivot table will change accordingly.
What I cannot figure out is how to add extra rows that will be reflected in
the pivot table. I can't find anyway to expand the data field in pivot table
options. Can anyone help?

EXCEL 2007

Click in the Pivot Table to launch the PivotTable Tools on the right hand
side of the Title Bar (highlighted in red).

Options / Data group / Change Data Source - this will highlight the data for
your existing Pivot Table / now extend the range as required and hit OK.

If my comments have helped please hit Yes.

Thanks.





"Max" wrote:

I know this might sound slightly simplistic, but my pivot table pulls data
from a separate tab. I know if I go in and amend the data in that table and
then save and restart, the data in my pivot table will change accordingly.
What I cannot figure out is how to add extra rows that will be reflected in
the pivot table. I can't find anyway to expand the data field in pivot table
options. Can anyone help?

That's perfect, thanks for the help. Much appreciated.

"trip_to_tokyo" wrote:

EXCEL 2007

Click in the Pivot Table to launch the PivotTable Tools on the right hand
side of the Title Bar (highlighted in red).

Options / Data group / Change Data Source - this will highlight the data for
your existing Pivot Table / now extend the range as required and hit OK.

If my comments have helped please hit Yes.

Thanks.





"Max" wrote:

I know this might sound slightly simplistic, but my pivot table pulls data
from a separate tab. I know if I go in and amend the data in that table and
then save and restart, the data in my pivot table will change accordingly.
What I cannot figure out is how to add extra rows that will be reflected in
the pivot table. I can't find anyway to expand the data field in pivot table
options. Can anyone help?

Hi Max

You should not be using a fixed range for your data source.
First create a Table, which will automatically grow in size as you add
more data, and then use this as the source for your PT.

Place cursor within your source dataInsert tabTableclick my data has
Headers
On the Design tab that appears,PropertiesTable Namegive it a
meaningful name

Change Source as described previously to the name you have given to your
Table. You will never need to change it again.
--
Regards
Roger Govier

Max wrote:
I know this might sound slightly simplistic, but my pivot table pulls data
from a separate tab. I know if I go in and amend the data in that table and
then save and restart, the data in my pivot table will change accordingly.
What I cannot figure out is how to add extra rows that will be reflected in
the pivot table. I can't find anyway to expand the data field in pivot table
options. Can anyone help?