I am about to destroy this program! it worked on my test pivot table
which is an exact copy of one of the pivot tables i needed it to work
on. I went back to my original workbook which contains three pivot
tables per page that i need dynamic charts for and it will not work
even though i have set it up the exact same way! it still gives me the
invalid reference to external data message but in no way am i
referencing ANY external data! I am very lost and saddened by this
since i was so confident it would work.


--
Acro
------------------------------------------------------------------------
Acro's Profile: http://www.excelforum.com/member.php...o&userid=35456
View this thread: http://www.excelforum.com/showthread...hreadid=552411