Data Model connecting several worhseet sheets into one table was used in Excel 2016. After creating the pivot table, I realized that there were spelling errors in my data set. By drilling down on in either the pivot table or the Append table, the offending worksheet is identified. Is there a way to correct the error on the Append table instead of correcting the error on the source table? I have tried correct the Append table and Refresh only to have the Apend table refreshed to the original data set.