Excel 2010 Pivot Table overlap

[Delta729]

This is probably a pretty general question, but all the answers I'm finding on the web were for earlier versions of Excel. I"m hoping they made this improvement in 2010. I have several pivot tables on the same Excel tab that when I add new data I get the message that they will overlap. Right now I added several extra row between them and then delete the un-used rows afterwards. (This is pretty much a pain...) Is there an option that would allow rows to be automatically added to avoid the overlap issue?

Thanks.

[dilipandey]

Hi Delta,

I also get this message while using Excel 2010.. not sure if they have improved on this

Regards,
DILIPandey

<click on below 'star' if this helps>