title: Incoherent pivot table results using extarnal data connection vs copied table
body: <p>I am facing a pivot table issue using external data connection.</p>
  
  <p>I have an excel file that contains information on different lines.</p>
  
  <p>I created external files with various pivot table to organize the data in the source file depending on the needs.</p>
  
  <p>A local pivot table copied in the external file provides 1 answer. The same pivot table based on external data connection provides incoherent information.</p>
  
  <p>same pivot table with different results:</p>
  
  <p><img src="https://i.stack.imgur.com/DK54U.jpg" alt="same pivot table with different results"></p>
  
  <p>When double-clicking on the results, the incoherent pivot table extracts information that is not in line with the data actually present in the source data file.</p>
  
  <p>extracted information by clicking on the erroneous pivot table:</p>
  
  <p><img src="https://i.stack.imgur.com/aCmVH.jpg" alt="extracted information by clicking on the erroneous pivot table"></p>
  
  <p>Sorry, I cannot add the third screen capture (limited rights as a new member)</p>
  
  <p>One side effect :
  On the erroneous pivot table, the drag-down list for filtering the "WBS - SO" column is complete with the correct pivot table (contains all the possible values) while in completely incomplete with the erroneous table (contains only numerical values, and I am not sure that it contains all the possible numerical values)</p>
  
  <p>I have searched the Net for Pivot Cache information and tried some of the solutions proposed but none worked.</p>
  
  <p>I have tried classical pivot and power pivot with the same result.</p>
  
  <p>Any idea extremely welcomed since I have been looking for a solution for 2 weeks.</p>
  
  <p>Thank you.</p>