Pivot Tableshttp://excelusergroup.org/forums/17.aspxPivot Table discussionsenCommunityServer 2008 SP1 (Build: 30619.63)Changing Pivot Table connection makes my dimensions disappearhttp://excelusergroup.org/forums/thread/5067.aspxFri, 06 Nov 2009 15:21:13 GMTafdc21cc-1618-45b1-a950-e47bb94e6e94:5067Anto0http://excelusergroup.org/forums/thread/5067.aspxhttp://excelusergroup.org/forums/commentrss.aspx?SectionID=17&PostID=5067<p>&nbsp;</p> <p>Hi.</p> <p>The heading says it all. Has anyone a clue of how to avoid this?</p> <p>I use Excel Macro to change the PivotCache.Connection. All dimensions are identical but still they just disappear.</p> <p>&nbsp;</p> <p>BR</p> <p>Anto</p> <p>&nbsp;</p><div style="clear:both;"></div>