pivot table help

[Kongming]

Hi all,

When making a pivot table, i am required to input a range of cells in order for the table maker to obtain relevant information. However, as I am constantly inputting extra data, these ranges always need to be increased. The only solution i know to this problem is to creat a new pivot table each time the data in ym worksheet has increased.

Is it possible to have a pivot table so that it automatically increases the range of cells it works with? And if so, how is this done?

Regards,

Kongming

 

[Richard Schollar]

Hi Kongming

Sure is! Set the datasource as a dynamic named range which will expand and contract as the data increases/reduces. Chip Pearson has a great page on the topic of dynamic ranges - see here:

http://www.cpearson.com/excel/excelF.htm#DynamicRanges

Best regards

Richard

 

[Kongming]

Richard,

Thank you very much for such a quick reply