I am using Excel 2013 and there are times when it will not let me choose the option add this data to the data model which gives me access to the distinct count function. Any idea why this is happening and how I can stop it. This is happening about 50% of the time.