I have created a pivot table with link to an external datas source.ODBC connection. Now my ODBC name keeps on changing from time to time. Any way to just pass the ODBC name as the parameter and it will refresh the pivot chart by running a macro.
Thanks in adv for assisting in this.