Still having a complete nightmare trying to work out why my powerpivot won't update. I always get the duplicate or inconsistent data error. If I go to manage relationships and turn off all the relationship for the sheet that wont update is that the same as deleting them? If it is then at least i know to focus on the inconsistent data even though I cannot see any issue.
Thanks Mike
Thanks Mike