Roger Govier that is an outstanding site, Thank you for you help.
"Roger Govier" wrote:
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?