Excel 2013 PivotTable Fields Range References
Dear Excel Experts,
I have a question concerning pivot tables added to the data model in Excel 2013.
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
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago