Excel Data Model without using PowerPivot
<p>I have a question about the "Data Model" in excel. Whenever I read about this function, it is used with PowerPivot.</p>

<p>I ask because I would like to do something like this:</p>

<p>I have <strong>table A</strong>:</p>

<ul>
<li>ID</li>
<li>info1</li>
</ul>

<p>And <strong>table B</strong>:</p>

<ul>
<li>ID</li>
<li>info2</li>
</ul>

<p>Now if I connect these tables with with the data model function (through the ID-Column), I thought that I could then join tableB.info2 to <code>tableA</code> and have a table that shows <code>ID,info1,info2</code></p>

<p>But that doesn't seem to be possible, or is it possible and I'm doing something wrong?</p>

<p>Is there ANYTHING you can do with datamodels without using PowerPivot? I feel like I'm missing the point of this feature.</p>