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
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