title: excel powerpivot update error "object was not found in the cube"
body: <p>I have an PowerPivot file that pulls data directly from a SQL data warehouse. Next it is fed into pivot tables. When I try and update I get the following error:</p>
  
  <p><strong><em>Query (20,3916) The level '&amp;[Desktop]' object was not found in the cube when the string, [OfficeFlatFile].TopicLevel2Name]&amp;[Desktop], was parsed.</em></strong></p>
  
  <p>I checked my data source and found that the member "Desktop" was no longer available (no surprise there). But I can't get the file to update now. I tried updating the PowerPivot data connection first but that didn't work either. </p>
  
  <p>This is the most recent info I could find, and it doesn't help. 
  <a href="https://connect.microsoft.com/SQLServer/feedback/details/756691/powerpivot-data-could-not-be-retrieved-from-the-exteral-data-source" rel="nofollow">https://connect.microsoft.com/SQLServer/feedback/details/756691/powerpivot-data-could-not-be-retrieved-from-the-exteral-data-source</a></p>
  
  <p>Does anyone know a solution apart from rebuilding the file?</p>