Excel Pivot Template

[Guest]

hi - please help! I have created a Pivot table template and each week I
import data from a large spreadsheet in this template. The data is exported
from Brio into the same spreadsheet each week and then I try to send that
data to my pivot table. How can I do this without having to create a new
pivot table each week?

 

[Debra Dalgleish]

You could use a dynamic range as the pivot table source, and it will
adjust automatically as the download changes. There are instructions here:

http://www.contextures.com/xlPivot01.html