Hello,
I'm relatively new to Power Pivot, however I've been using excel since the mid 90s and so know a lot of the older advanced features. I also have experience with relational databases, so the relationship function of Power Pivot is what interests me most.
I'm just working on my first live Power Pivot report for actual consumption, and recently (at random times without any specific trigger) the Data Model gets corrupted such that every time I try to refresh the table the error comes up "We cannot load the data model. Object reference not set to an instance of an object" The only way to clear the error is to delete all relationships and power pivot tables and start over. In fact, in one instance even that could not be done because Excel won't allow deletion of the workbook connections and the relationships - so the only solution was to copy the data to a brand new workbook.
Has anyone experienced this? Is there a way to "reset" the data model in some way?
So far it's working Ok and I am very careful to save each and every time before making changes, but sometimes forget and having a better recovery plan would be nice.
Another solution would be some way to enable an actual save in the background every minute (not an autosave, which is unreliable). I have the file saved to a dropbox with unlimited history, so each time there is a save it creates a new version which can be easily restored. The problem is remembering to press save every single time, which I often forget.
Thanks
I'm relatively new to Power Pivot, however I've been using excel since the mid 90s and so know a lot of the older advanced features. I also have experience with relational databases, so the relationship function of Power Pivot is what interests me most.
I'm just working on my first live Power Pivot report for actual consumption, and recently (at random times without any specific trigger) the Data Model gets corrupted such that every time I try to refresh the table the error comes up "We cannot load the data model. Object reference not set to an instance of an object" The only way to clear the error is to delete all relationships and power pivot tables and start over. In fact, in one instance even that could not be done because Excel won't allow deletion of the workbook connections and the relationships - so the only solution was to copy the data to a brand new workbook.
Has anyone experienced this? Is there a way to "reset" the data model in some way?
So far it's working Ok and I am very careful to save each and every time before making changes, but sometimes forget and having a better recovery plan would be nice.
Another solution would be some way to enable an actual save in the background every minute (not an autosave, which is unreliable). I have the file saved to a dropbox with unlimited history, so each time there is a save it creates a new version which can be easily restored. The problem is remembering to press save every single time, which I often forget.
Thanks