update pivot table

[Mia]

I have a sheet of info. which used to create the pivot table. I need to update
this sheet every week. How can I set so every time when I update the sheet,
the pivot table will be automatically update.

Your help is very much appreciated.

If anyone would please show me how to look in the archive, that would be
great too.

Mia

 

[Debra Dalgleish]

If you're adding new rows of data to the source every week, you can use
a dynamic formula to name the data source range, and use that as the
source for the PivotTable. There are some instructions here:

http://www.contextures.com/xlPivot01.html#Dynamic

To search the archives, you can use the Advanced Search page on the
Google web site, with *excel* as the newsgroup:

http://groups.google.com/advanced_group_search?as_ugroup=*excel*