Multiple Pivot Tables with Data model - Source Problem

Hi,
I'm trying to create multiple pivot tables in a worksheet, both of which use data models. The code is as below

Please Login or Register  to view this content.

Please refer the attachment given below. Both pivot tables gets created fine. But, the second pivot table does not use the new connection reference and uses the data of the old file itself. Any idea y? I'm using , Excel 2013, 64 bit version.

Bump to top