2 Replies Latest reply on Feb 3, 2013 8:07 AM by Eric Wolf

    Is there a way for multiple Excel worksheets in DIFFERENT workbooks to behave the same way as Excel worksheets in the same workbook?

    Eric Wolf

      I'm trying to join data across multiple Excel worksheets.  If the worksheets are in the same workbook, the Tables command does just what I want - give me a single joined data set allowing me to do, for instance, calculations using fields from different worksheets.  However, if the worksheets are in different workbooks, I don't seem to be able to accomplish the same thing.  Edit Relationships" looks a lot like a join, but doesn't seem to do the same thing.  Thoughts?  Guidance? 

       

      I think I am missing something basic here.

       

      Eric