Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot table
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot table
Ed,
right click in the pivot table, choose pivot table wizard, then back, then select the required range with your mouse ED wrote: 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 -- Message posted via http://www.officekb.com |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot table
Hi Ed
Which version of Excel are you using? for any version of Excel, you can create a Dynamic Range. e.g. InsertNameDefineName 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 toolbarBackenter =myTable as the sourceFinish 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 DataCreate Listclick 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 tabTablemy list has headers. A Dynamic Table will be created which can be used as the source for your PT. -- Regards Roger Govier "ED" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot table
If you base your Pivot Table on a Dynamic Range Name, the range will
automatically expand and contract to accommodate the data. See this website for instructions: http://www.contextures.com/xlNames01.html#Dynamic Does that help? *********** Regards, Ron XL2002, WinXP "ED" wrote: 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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot table
Right click the table and select the pivot table wizard, click the back
button and then change the size of your table, if you keep adding rows you might want to check here http://www.contextures.com/xlPivot01.html -- Regards, Peo Sjoblom "ED" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot table
Thank you, great help.
"Peo Sjoblom" wrote: Right click the table and select the pivot table wizard, click the back button and then change the size of your table, if you keep adding rows you might want to check here http://www.contextures.com/xlPivot01.html -- Regards, Peo Sjoblom "ED" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
Pivot table keeps dupping to another linked pivot table | Excel Discussion (Misc queries) | |||
pivot table: create worksheetsheet using pivot table | Excel Discussion (Misc queries) | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel |