title: Excel "Cannot Open PivotTable Source" error when opening directly to Excel from DL
body: <p>I have a website that generates some Excel spreadsheets and provides a download link to the end-user.  One of these spreadsheets is a fairly convoluted one with multiple charts based on multiple pivot tables.</p>
  
  <p>For a few of our users, when they choose to "Open" the file immediately (as opposed to "Save As" to put it in a known path), we are running into problems when trying to refresh the pivot tables: </p>
  
  <p>Cannot open PivotTable source file: 'C:\Users\joeuser\AppData\Local\Microsoft\Windows\Temporary Internet Files\Low\Content.ie5\W9IZXYBM[excel_file_name.xlsm]PivotTableSourceSheetName'</p>
  
  <p>If the user chooses "Save" instead of "Open", the refresh works fine, so our users have a workaround, but can anyone shed light on what might cause only a few users to have this problem with the "Open" scenario?   We haven't spotted anything glaringly different between machines that "Open" the file just fine and those that don't.  Same browser versions, same Office versions, etc.</p>