Pivot Table refresh - false error

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

Originally Posted by Calieth

...
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 ...

If I may, my earlier recommendation was only to go through the worksheet which holds all the pivot tables ... since this kind of problem is very often due to the initial design ...

Originally Posted by JeanRage

If I may, my earlier recommendation was only to go through the worksheet which holds all the pivot tables ... since this kind of problem is very often due to the initial design ...

Oh certainly, and no offense meant at all. I appreciate any and all advice. I was just looking to see if perhaps there was a way to find or correct the error through code or another method. I'm new to the forums and unsure if everyone reads all the different forums and I hadn't put this problem here to look for coding help.

Sadly, I've checked back through the original pivot tables and can not find any reason at all for the problem. I was just looking to see if anyone had a different method to approach it. I do apreciate your help.

It's a shame you can't post your file ...
because, for sure, several contributors could then spot the problem ... and fix it for you ...

Wow. I can't believe that was it. I feel so silly for missing it. In those tables, an extra clinic code snuck in when I added extra lines in the data and I needed to remove it as well. Probably why those tables got so long.

Thanks so much for all your help!