Skift ekstern datakilde for pivot tabel

Hej mwahl

Jeg vil gøre følgende:

--KLIP--

1. Open the sheet that has the pt that you want to change
2. Select the pt whose connection you want to change
3. Hit alt+f11 (this brings up the vbe enviornment)
4. Hit ctrl+g (this will place the cursor in the immediate window and open
it if it does not already exist)
5. In the immediate window type and hit enter:

?activecell.PivotTable.PivotCache.Connection

6. You should get something back like:

ODBC;DRIVER=SQL Server;SERVER=xxx;UID=xxx;;APP=Microsoft Office
2003;WSID=xxx;DATABASE=Northwind

7. You will note the server name above is xxx.
8. You can then set the Connection property as follows

activecell.PivotTable.PivotCache.Connection = "ODBC;DRIVER=SQL
Server;SERVER=<Enter your new server name here>;UID=xxx;;APP=Microsoft
Office 2003;WSID=xxx;DATABASE=Northwind"
--KLIP--

Håber at det løser dit problem.