Editing data model source dataset

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.

 

By: Deanna

Leave a Reply

Your email address will not be published. Required fields are marked *