title: Recognize which Excel pivot tables will overlap after refresh
body: <p>Within extensive Excel files (=approx. 40 sheets) there are many pivots (drawn from a single OLAP cube; hence one connection for all pivots). Often, there are several pivot tables within the same worksheet. </p>
  
  <p>Whenever there were changes to the OLAP cube, it might take a long time to find out which of those cause an overlap and hence lead to a cancellation of a refresh. <strong>Is there a way to find out which out of many pivot tables leads to an overlap when refreshing the connection?</strong> </p>
  
  <p><strong>Side conditions:</strong> holding each pivot table in a separate sheet is not an option (to many sheets), converting the data to cube functions neither. </p>