How to change the connection string in powerpivot by script?

Question

How to change the connection string in powerpivot by script, so i can put it in one cell ?

Answer 1

There is no supported API in PowerPivot v1. You can't change anything via script.

---

http://geekswithblogs.net/darrengosbell - please mark correct answers

Answer 2

Maybe, but the connection is just part of the connections collection, so that is exposed to VBA.

 

Dim cnn As Object

 

    For Each cnn In ThisWorkbook.Connections

   

        If cnn.Name = "PowerPivot Data" Then 'old versions used 'Sandbox'

       

            MsgBox cnn.OLEDBConnection.Connection

        End If

    Next cnn

 

 

But I fail to see the logic, there is just the one connection to PowerPivot, and what can you change it to?

 

HTH

Bob

"Darren Gosbell [MVP]" wrote in message news:[e-mail]...

There is no supported API in PowerPivot v1. You can't change anything via script.

---

http://geekswithblogs.net/darrengosbell - please mark correct answers

Answer 3

 But I fail to see the logic, there is just the one connection to PowerPivot, and what can you change it to?

That's just the connection from the pivot table to the PowerPivot model.

As I said there is no supported API for PowerPivot, you can't "see" the connects from PowerPivot to the source data.

---

http://geekswithblogs.net/darrengosbell - please mark correct answers

Answer 4

Which IS the connection string, because it connects to the local cube.

 

HTH

Bob

"Darren Gosbell [MVP]" wrote in message news:[e-mail]...

But I fail to see the logic, there is just the one connection to PowerPivot, and what can you change it to?

That's just the connection from the pivot table to the PowerPivot model.

As I said there is no supported API for PowerPivot, you can't "see" the connects from PowerPivot to the source data.

---

http://geekswithblogs.net/darrengosbell - please mark correct answers

Answer 5

Maybe I'm misunderstanding something about the question, but I can't see why you would change that connection string. That connection uses an in-memory transport. I haven't tried, but I suspect that if you change it all that will happen is that the PivotTable will break.

---

http://geekswithblogs.net/darrengosbell - please mark correct answers

Answer 6

That was exactly my point in my original reply.

 

Bob

"Darren Gosbell [MVP]" wrote in message news:[e-mail]...

Maybe I'm misunderstanding something about the question, but I can't see why you would change that connection string. That connection uses an in-memory transport. I haven't tried, but I suspect that if you change it all that will happen is that the PivotTable will break.

---

http://geekswithblogs.net/darrengosbell - please mark correct answers

Answer 7

That was exactly my point in my original reply.

 

Bob

"Darren Gosbell [MVP]" wrote in message news:[e-mail]...

Maybe I'm misunderstanding something about the question, but I can't see why you would change that connection string. That connection uses an in-memory transport. I haven't tried, but I suspect that if you change it all that will happen is that the PivotTable will break.

---

http://geekswithblogs.net/darrengosbell - please mark correct answers

Which was the point of my original reply.

The only connections that it makes any sense to change in relation to PowerPivot are those used to populate the model with data. And there is no supported API to change those.

---

http://geekswithblogs.net/darrengosbell - please mark correct answers