We have used pivot tables extensively here for several years. FWIW her
are a couple of ideas to make them easier to work with.

1. Set up a pivot table manually. Change the base data when necessary
and refresh (using VBA code).

2. Add new data (eg. monthly) to the bottom of the old and use a
additional column for "Month".

3. Add calculated columns etc to the *base data* wherever possible
rather than pt calculated fields. Can use dynamic named ranges.

4. Do not format a pivot table. Use it as a feed between the data and
properly formatted report. The pt can be hidden if required. Usuall
VLOOKUP() is all that is needed.

5. You do not necessarily have to include base data in the sam
workbook (keeps the size down).

6. If you really need to use code for seting up etc. use the macr
recorder (eg. Select, PivotTableWizard method, etc.). This is les
prone to bugs & other 'strange' problems

--
Message posted from http://www.ExcelForum.com