Hi there I have added new data to table that I used to build my Dashboard.I have try to update my pivot tables used in the dashboard by pressing refreshpivot but get Message “A pivot table report cannot overlap anotherpivot table report.” Even when I put thepivot in a new sheet I get the same message. When can get the pivots to update the new data the entirepivot field setting are changed and removed and so are filter so basically I haveto create the pivots again. So there no automatic refresh on the dashboard I didn’tthink it would be this complicated. Does anybody have ides how to get this to run smooth? Thanks Leicester City Fox

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Update data table but pivots will not automatically update

Thread starter Leicester City Fox
Start date Dec 8, 2016

Leicester City Fox

Board Regular

Dec 8, 2016

Hi there<o

></o

>
I have added new data to table that I used to build my Dashboard.I have try to update my pivot tables used in the dashboard by pressing refreshpivot but get Message “A pivot table report cannot overlap anotherpivot table report.”<o

></o

>
Even when I put thepivot in a new sheet I get the same message.<o

></o

>
When can get the pivots to update the new data the entirepivot field setting are changed and removed and so are filter so basically I haveto create the pivots again.<o

></o

>
<o

> </o

>
So there no automatic refresh on the dashboard I didn’tthink it would be this complicated.<o

></o

>
Does anybody have ides how to get this to run smooth? <o

></o

>
Thanks<o

></o

>
<o

> </o

>
Leicester City Fox<o