You are reading a single comment by @peter_h and its replies. Click here to read the full conversation.
  • If you are using an earlier file as a template, insert however many new columns you need into the old data range paste the new data over it, rather than adding them as extra columns to the right. If you do it this way, the data source range will automatically adjust and the new fields wil appear when you refresh the pivots

About

Avatar for peter_h @peter_h started