|
| 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
May 3rd, 2005, 08:09 PM
|
|||
|
|||
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
May 3rd, 2005, 08:17 PM
|
|||
|
|||
|
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 |
Linear Mode
