I saw a similar question in an earlier post and tried to use the solution but was not able to get it to work.

I have a pivot table in sheet Table1, workbook Monitor1. My data is in sheet "Data". over the course of the day, I add data and was hoping there was a macro that would expand the data range of the pivot table and refresh the table to reflect the new data.

Thanks in advance for your help.