title: Why is using Power Pivot getting the Data Model deleted in Excel?
body: <p>I am using Power Pivot to do some analysis and then make Pivot tables from the data model. There are more then 1 interconnected tables. The tables have been created using Power Query. The relationships are created using Power Pivot.</p>
  
  <p>After my work is done and the Excel File is closed, the data model gets deleted. I can see that as the file size gets reduced. Also when I open the file and try to modify the pivot tables receive the following message: " the connection for this pivot table has been Deleted". The queries that were created using power query do not refresh either (Shows: Download Failed).
  When I open the Power Pivot for Excel window, it does not show any tables in it.</p>
  
  <p>I am using Microsoft Professional Plus 2016. Already Repaired MS Office.</p>
  
  <p>Would really appreciate if any one can help.</p>
  
  <p>Thank you.</p>