Prev: find and copy it..
Next: Mandatory/Compulsory
From: Max on 20 Apr 2010 23:10
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?
From: trip_to_tokyo on 20 Apr 2010 23:40
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?
From: Max on 21 Apr 2010 02:08
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?
From: Roger Govier on 21 Apr 2010 08:41
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 data>Insert tab>Table>click my data has
Headers
On the Design tab that appears,>Properties>Table Name>give 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?
 | 
Pages: 1
Prev: find and copy it..
Next: Mandatory/Compulsory