Hi Debra.

I tried what you sent to me in steps 1 & 2 on your webpage and the column I
need (F5) doesn't work properly in displaying that data that row in the pivot
table. F5 shows the previous data and not the data i entered. D5 is fine.

I used these as per my worksheets with multi consolidation:
Range named as "DynamicPivot1" for 1st worksheet and DynamicPivot2 for
2nd... etc.

=OFFSET('1st'!$D$5,0,0,COUNTA('1st'!$D$5:F91),7)
=OFFSET('2nd'!$D$5,0,0,COUNTA('2nd'!$D$5:F91),7)

* Using the above, the range seems unlimited rows where I would liek it to
stop at F91.
* Tried the above and noticed the F91 range changes to another cell like F70
for some reason.
* Tried variations like:
=OFFSET('1st'!$D$5,0,0,COUNTA('1st'!$D$5:F91),3)
=OFFSET('2'!$D$5,0,0,COUNTA('2'!$D$5:F91),3)
"3" because F column is the last for pivoting/charts from "D".

Next creating the pivot, I named the range as:
DynamicPivot1
DynamicPivot2
After this, F5 column will not refresh the correct data for that row.

Help.


"Debra Dalgleish" wrote:

You can create dynamic ranges for the data, and refer to those when
adding the multiple consolidation ranges. There are naming instructions
he

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

sean wrote:
Problem with multi consolidation.

After a pivot table and chart are created, within the data ranges of the
source data more data is added but the data will not display upon refreshing
the pivot. Why is that?

So, having many worksheets using multi consolidation pivot, if any extra
data is added to the worksheets within the pivot source range, when
refreshing the pivot table/chart, that data will show up in the pivot.

This is a sticking point for the purpose required.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html