I keep getting the message "A pivot table report cannot overwrite another piot table report" when I refresh the data in my pivot table................I do not know what is the cause of this ???
I guess you have 2 pivot tables on the sheet. Pivot tables normally
expand in size when data is added. If the pivot table expanded it would
overwrite the other table. You will need to move a table to allow extra
space between.