Pivot Table Won't Update - Please Help

[eryksd]

Edit: I think I figured it out, I had to change data source so that it picks up the rest of the data, was only going down like 400 columns

-------------------------------




For the forecasting excel file Pivot Table (in sheet "Historical Pivot"), do you know how to make the pivot table fill in the other months (June 2017, July, etc)?

I hired a contractor to get my pivot table to work, however now I can't figure out how to add more months to my forecasting sheet.

My data is being filled in from the "Historical Sales" sheet.

Screenshot: 2018-06-06_1515.png

Edit: I think I figured it out, I had to change data source so that it picks up the rest of the data, was only going down like 400 columns

[FDibbins]

Sounds like you worked it out. Did that in fact, fix the problem?

[kersplash]

What you should do is put your source data in a table and link your pivot table to the table rather than a fixed range.

When you refresh your pivot table you don't need to change the range each time as any new data is a part of the table.