OK so get this, apparently we are to switch to ms active directory which
means that all the data sources need to be renamed.

I have a list of over 60 excel files using around 6-7 pivot tables each, and
all i need to do is change the dsn data source system name!!!!

is there any way to do this without having to recreate the dammed dsn for
every pivot table? Is there maybe a script that I could write ???

SOMething ... someone please help, this will take more than a year for me to
redo ... ugh ...