I have a pivot table set to update immediately via Pivot App, but whenever I add to/refresh the data in the source sheet, the pivot table will often reflect duplicate rows/values.
I have a source sheet with individual lines of data for a resource's time on each project he/she is working on.
In the returned pivot sheet, there are often two lines for one resource (with the same data). Any ideas why this might be happening?