Pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to "Refresh the Data" for my Pivot Table.

My data is a lot longer then it used to be. How do I make sure that all
numbers are included in the pivot table.

Right now the last three rows are cut off.

Thanks.
E
 
Ed,

right click in the pivot table, choose pivot table wizard, then back, then
select the required range with your mouse
 
Hi Ed

Which version of Excel are you using?
for any version of Excel, you can create a Dynamic Range.
e.g.
Insert>Name>Define>Name> myTable Refers to
=OFFSET($A$1,0,0,COUNTA($A:$A),COUNTA($1:$1))

This assumes that your table starts at A1, and has headers in row 1.
Adjust if different.

The formula also assumes that there are no blank entries in column A. If
there are, choose a column for the first COUNTA where there will not be
nay blanks.
Invoke the PT Wizard from the PT toolbar>Back>enter =myTable as the
source>Finish

For more information on Dynamic Ranges take a look at Debra Dalgleish's
site
http://www.contextures.com/xlNames01.html#Dynamic

If you are using XL2003, whilst in any cell within your source data,
choose Data>Create List>click my table has headers.
This will create a dynamic List for you which you can use as the source
for your PT.

If using XL2007, then on the ribbon choose Insert tab>Table>my list has
headers.
A Dynamic Table will be created which can be used as the source for your
PT.
 
Back
Top