Power pivot report developed in local machine, database connection..is not refreshing data when uploaded to different
server.is there possible way to
"set the database connection settings to dynamic in power pivot excel."
tnkx ,any reply is appreciable
We can use VBA to achieve your requirement. Please refer to Chris Webb's blog below:
Parameterising PowerPivot Connection Strings in Excel 2013:
TechNet Community Support
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?