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

7 thoughts on “Editing data model source dataset

  1. fila

    After research a number of of the blog posts on your web site now, and I truly like your way of blogging. I bookmarked it to my bookmark web site list and will be checking again soon. Pls check out my web site as nicely and let me know what you think.

  2. air max 270

    Can I simply say what a reduction to seek out somebody who really knows what theyre talking about on the internet. You definitely know find out how to deliver a difficulty to gentle and make it important. More people need to read this and understand this side of the story. I cant consider youre not more widespread since you positively have the gift.

  3. jordan 4

    I抦 impressed, I must say. Really not often do I encounter a weblog that抯 each educative and entertaining, and let me let you know, you’ve hit the nail on the head. Your concept is excellent; the issue is something that not enough people are talking intelligently about. I’m very pleased that I stumbled throughout this in my seek for one thing referring to this.

  4. michael kors handbags

    There are some fascinating cut-off dates in this article however I don抰 know if I see all of them center to heart. There is some validity however I’ll take hold opinion till I look into it further. Good article , thanks and we wish extra! Added to FeedBurner as effectively

Leave a Reply

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