title: PivotTable connection timeout was exceeded
body: <p>I am creating a PivotTable in excel and pulling data from SSAS multidimensional cube, however when I select a measure to be shown in PivotTable then OLAP query runs in the background for 60 seconds and then it throws following error:</p>
  
  <blockquote>
    <p>The Connection timeout was exceeded</p>
  </blockquote>
  
  <p>I've increased Analysis server property <code>ExternalConnectionTimeout</code> from 60 to 180 but even then my PivotTable throws same error after 60 seconds. </p>
  
  <p>Please let me know how can I fix this issue?</p>