---
title: "Hur ändrar man datakälla i en excel pivottabell?"
type: "forum-thread"
url: "https://www.webforum.nu/amne/kontorsprogram/125566-hur-ändrar-man-datakälla-i-en-excel-pivottabell"
topic: "Kontorsprogram"
topic_url: "https://www.webforum.nu/amne/kontorsprogram"
author: "mattiasnordin"
published: "2005-04-01T09:45:16.000Z"
updated: "2005-04-01T15:58:43.000Z"
replies: 3
views: 741
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/kontorsprogram/125566-hur-ändrar-man-datakälla-i-en-excel-pivottabell"
---

# Hur ändrar man datakälla i en excel pivottabell?

## #1 — mattiasnordin, 2005-04-01T09:45Z

Jag har samma problem som nedan.
<http://www.mrexcel.com/archive/Pivot/26528.html>

Det verkar vara så att pivottabeller sparar både ODBCkopplingens användarnamn och lösenord lokalt i Excelfilen. Är det någon som vet hur man ändrar denna cachade information. Oerhört irriterande.

Permalänk: https://www.webforum.nu/p/125566

## #2 — mattiasnordin, 2005-04-01T09:47Z

> \--------------------------------------------------------------------------------
>  
> Joozh,
> 
> Excel uses OLEDB for OLAP and you can choose between a non specific version and version 8.0, I have always used the one called
> 
> Microsoft OLE DB provider for OLAP services 8.0.
> 
> Please note that this is Excel XP. XP has a far superior version of pivot table services to Excel 2000 and on our machines here, people who need to use the OLAP reports have Office 2000 installed for their normal work and Excel XP installed on top. (N.B. it has to be on top as fixing or reinstalling Office 2000 messes up Excel XP)
> 
> The connection is controlled by the PivotCache object with properties such as
> 
> CommandText
> Connection 
> 
> and assorted methods
> 
> e.g. Refresh
> 
> The Connection is the connection string such as
> OLEDB;Provider=MSOLAP.2;Persist Security Info=True;Data Source=SERVERNAME;Initial Catalog=OLAPDATABASE;Client Cache Size=25;Auto Synch Period=10000 
> 
> where you'd replace SERVERNAME & DATABASENAME (actually I meant OLAPDATABASE!) with the relevant info
> 
> I think that CommandText may be the cubename although I can't quite remember
> 
> You can see this information in Excel, using VBA by doing something like
> 
> Sub PTinfo()
> MsgBox ActiveSheet.PivotTables(1).PivotCache.CommandText
> 
> MsgBox ActiveSheet.PivotTables(1).PivotCache.Connection
> End Sub
> 
> Which will pop up message boxes with the information about the cubes. I have used this reasonably effectively for management of our reports and also by using the replace function I can change the servers that the reports point at thereby relatively easily rolling out the changed reports from Development to Live.
> 
> Hope this helps,
> 
> Regards,
> 
> Robert.

Permalänk: https://www.webforum.nu/p/1582818

## #3 — mattiasnordin, 2005-04-01T13:22Z

Det här verkar vara ett seriöst problem. Hittar en massa trådar om folk som frågar efter en lösning men inte några lösningar.

Vem vill vara först ?! HJÄLP :)

Permalänk: https://www.webforum.nu/p/1582933

## #4 — mattiasnordin, 2005-04-01T15:58Z

Mycket intressant problem. Verkar dock vara fixat i office 2003. Har du skapat dokumentet i en tidigare version så har du en guide för att fixa problemet [här](http://mattiasnordin.net/web2005/forum/forum_posts.asp?TID=40&PN=1&TPN=1).

Permalänk: https://www.webforum.nu/p/1583021

---

Tråden på webben: https://www.webforum.nu/amne/kontorsprogram/125566-hur-ändrar-man-datakälla-i-en-excel-pivottabell