Pivot Table does not refresh with current data - Microsoft Community

have pivot table has columns named each month.  the rows beneath contain categories vendors listed under each category.  the columns contain accounting data each month.  the pivot table supposed populate new column when data new month entered on input sheet.  this table has refreshed in past no longer adds next month.  is there way correct problem?  my other choice delete , create new pivot table.  any can offer appreciated.  bjw>

when create table - assigned name (typically "table1") . can see on table tools...design on ribbon shows on ribbon when in table. change data source of pivottable table's name , whoola it's in pivottable field list.

Office / Excel / Mac / Office 365 Home