Pivot table refresh problem

Hello All!

Problem: Getting error message of "Pivot tables can not overlap" but tables not overlapping.

I've created a budget workbook with a data page containing all the data for my pivot table. It has fields such as:

• Date (data already filled in)
• Unit Targets (data already filled in)
• Units Collected (blank and ready for data to be added each day)

I've also created a tab for each Month, and a Year-End Summary Tab. I have multiple pivot tables on each page to make it more user friendly for managers who are just not as comfortable manipulating the tables themselves, and would rather have a few standard views showing.

The point is to update the data tab each day with the day's collections. But the problem shows up when I refresh the data in any of the pivot tables. I get the standard error message that Pivot Tables can not overlap. But nothing is changing except the addidtion of the Units Collected fields being populated with a number instead of being blank. No new rows or columns.

Therefore, I have to hit "OK" about 6 times before it just shows the data properly wth no conflicts or overlaps. But my managers will not want to do this and will be alarmed. Can anyone tell me why this is happening, and perhaps what to do about it?

Thanks

Hi,

Without seeing your file, it is difficult to give you a precise answer ...

But generally speaking, it is related to a design issue ...

For sure, you have made several attempts, combining several pivot tables in the same worksheet ...
If possible, leave enough room " to grow" to each pivot table ...

HTH

I guess my question is if the table is not 'growing' at all, just filling in blank cells, then why would it need room to grow?

Additionally I have a minimum of 10 rows between each table.

To be on the safe side ...the ideal thing to do is to consider your actual worksheet as a draft ... and rebuild from scratch your pivot tables ... for sure, the error message will disappear ...

HTH