Hi Terry

Consolidating multiple ranges in PT's does not behave exactly as you would
expect.

Take a look at Debra Dalgleish's site
http://www.contextures.com/xlPivot08.html

--

Regards
Roger Govier

"Terry" wrote in message
...
Thank you Mike H. for your help!

"Terry" wrote:

Is it possible to use a pivot table to combined mutable work sheet in
different folders?