Excel Pivot Table error

#1

Hi,

I'm using an excel pivot table to query a cube. Haven't had a problem in the
past, but today, I opened up a workbook and tried to refresh the data in the
pivot table and got the following error:

Cannot change thread mode after it is set

I also get it trying create a new pivot table, and it's occuring for
different servers.

Has anyone seen this error before?

I'm running SQL Server 2000, SP3, and Excel 2002.

Thanks,
Wreck.

#2

Hello Wreck,

It seems to be an issue inside Excel or in OWC. I suggest that you try to
remove/reinstall OWC to test the sitaution. You could remove it from Office
XP components and download it from the following link:

http://office.microsoft.com/en-us/of...aspx?iStartAt=
1

Also, please check if the issue occurs on a different client to isolate a
server side issue.

Since it is most likely a client side issue, it is suggested that you post
the problem in Excel newsgroup.

Have a great day!

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

Quote:

Thread-Topic: Excel Pivot Table error
thread-index: AcWdVV3FqwWSOJGYTjm9S6wtYBWSNQ==
X-WBNR-Posting-Host: 202.3.198.20
From: "=?Utf-8?B?V3JlY2s=?=" <Wreck (AT) community (DOT) nospam
Subject: Excel Pivot Table error
Date: Tue, 9 Aug 2005 19:44:02 -0700
Lines: 19
Message-ID: <3AA5072E-A38F-491E-9441-DE2CC587B7E0 (AT) microsoft (DOT) com
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.sqlserver.olap
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.olap:13684
X-Tomcat-NG: microsoft.public.sqlserver.olap

Hi,

I'm using an excel pivot table to query a cube. Haven't had a problem in
the
past, but today, I opened up a workbook and tried to refresh the data in
the
pivot table and got the following error:

Cannot change thread mode after it is set

I also get it trying create a new pivot table, and it's occuring for
different servers.

Has anyone seen this error before?

I'm running SQL Server 2000, SP3, and Excel 2002.

Thanks,
Wreck.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Excel Pivot Table error

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Excel Pivot Table error - 08-09-2005 , 09:44 PM

RE: Excel Pivot Table error - 08-10-2005 , 01:31 AM