Forum Discussion
Need help with changing data source of Pivot table
Hello All! I have been trying to figure this out for a few months now. I am trying to update the data source of a pivot table but I keep getting the following message: "There's already data in <name...
gamilh Pivot tables may extend away from its origin (right and down). That's why you should never place anything below or to the right of a pivot table, unless you are 100% sure that it will never expand as much so that it will overlap existing data.
Redesign you report so that the added calculations and charts are placed above or towards the left of the pivot table.
Riny_van_Eekelen Thank you for your response and time! That is my plan B right now. I was hopeful that I can find something to make it work. At this point, your suggestion is what I would probably have to do.
Again, thank you for your time!
