Results 1 to 5 of 5

Thread: Excel 2013 PivotTable Fields Range References

  1. #1

    Angry Excel 2013 PivotTable Fields Range References



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Alt-D-P> Multiple Consolidation Ranges>...

  3. #3
    Thanks a lot for The answer Bob. But my Tables Contain duplicates.

  4. #4
    I don't see what that has to do with your original question. Nor do I see the relevance as a pivot aggregates them does it not?

  5. #5

    Hi Bob, I am looking for the following:

    the code items 1,2,3 are coming from 3 different worksheets respectively.
    Click image for larger version. 

Name:	Question1_short.jpg 
Views:	17 
Size:	70.6 KB 
ID:	2812

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •