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

Looking for: Solution which can include code to fix or work around problem or a different approach to pivot tables.

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. I have at least 10 rows between each pivot table even though that shouldn’t be necessary.

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 Units Collected fields being populated with a number instead of being blank. No new rows or columns.

Therefore, I have to hit "OK" to the error message about 6 times before it just shows the data properly with 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?

It was recommended in another post to just redo the entire workbook from scratch. But this is a very complex workbook and I have an operation deadline of April 1. So any other suggestions would be welcome. If not, I will have to figure out a way to work around it.

Thanks