title: Why does excel create multiple ranges for a data model Pivot? And how to consolidate or prevent this from happening?
body: <p>Below is the issue I am facing and would like to have only 1 range for all the pivots.
  Is there any easy way to prevent this from happening and how to fix it?</p>
  <p><a href="https://i.stack.imgur.com/j669N.png" rel="nofollow noreferrer">Multiple ranges created by excel for a datamodel pivot</a></p>