title: Mass update Excel file connection string
body: <p>We have recently changed our SQL Database server and i was wondering if there would be a script or an easier method of updating all the Excel file connection strings?</p>
  
  <p>It would of been alot easier if they used a connection file but unfortunately they were all set manually and we have about 600 reports...</p>
  
  <p>Any help is much appreciated.</p>
  
  <p>Thanks</p>
  
  <p>Nick</p>