Hello,
I am testing the Link table errors feature and changed the linked table name in the Excel workbook.
I also changed the format of a date field to currency.
When I refreshed the data in PowerPivot and opened the Select Action dialog box, I was expecting to see 2 errors. There was only one for changing the table name. I fixed that error, clicked OK.
Then I got an error message saying that the table name could not be updated because of conflicting data types.
I looked on the PowerPivot tutorial on technet, but the page for the Select Action dialog box, doesn't provide any information to explain why all errors listed on that page were not on the Select Action dialog box.
Any help would be greatly appreciated.
Thank you