Dear Excel Experts,

I have a question concerning pivot tables added to the data model.

Somehow I managed that one (PivotTable fields) range refers to three different tables in three different worksheets of the same workbook. But I donít know anymore how I came to this result.

All other attempts produced ranges that refer to only one table.

I have been looking for seven hours in the internet and in my Excel books. And didnít find any answer.

Can you explain to me how I produce a range that refers to three different tables in three different worksheets?

Thanks for your effort.

Best wishes

Luc