If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot Tables: Can I get cells to duplicate downward automatically?
I am currently using PivotTables and am wondering if there is a way for the
table to automatically appear with all of the cells 'filled-in' down a column without having to do it manually after it appears? |
#2
|
|||
|
|||
Do you mean when the source data has been changed? If so you can use a
dynamic table and refer to it then just refresh the pivot table there are instructions for here http://www.contextures.com/xlPivot01.html Regards, Peo Sjoblom "StrawberryGirl" wrote: I am currently using PivotTables and am wondering if there is a way for the table to automatically appear with all of the cells 'filled-in' down a column without having to do it manually after it appears? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pivot tables - inserting columns | Scott | Worksheet Functions | 1 | March 19th, 2005 01:07 AM |
Blank Cells in Pivot Tables | Greg | General Discussion | 1 | March 16th, 2005 09:23 PM |
Pivot Tables In Access 2000 and 2002 | truttman | General Discussion | 0 | January 4th, 2005 05:05 AM |
Pivot Tables Rows | hans | General Discussion | 2 | June 22nd, 2004 11:26 AM |