PC Review


Reply
Thread Tools Rate Thread

How to change Pivot when SQL data source fieled name changed

 
 
=?Utf-8?B?Tm9kYWs=?=
Guest
Posts: n/a
 
      3rd Aug 2005
Q: How to change Pivot when SQL data source field name changed

I have a Pivot table that accesses a SQL data source.

When one of the Fields Names in SQL is changed there is an error when trying
to refresh Pivot Table.

I cant find a way to edit the Pivot Table MS Query for the new SQL Columns
Name like I can when just using MS Query to import data into excel vs into
Pivot.

Is this possible?

 
Reply With Quote
 
 
 
 
=?Utf-8?B?Tm9kYWs=?=
Guest
Posts: n/a
 
      4th Aug 2005
Resolution: Call up the "Pivot Table Wizard" and hit Back Button to retrace
steps and change data source

"Nodak" wrote:

> Q: How to change Pivot when SQL data source field name changed
>
> I have a Pivot table that accesses a SQL data source.
>
> When one of the Fields Names in SQL is changed there is an error when trying
> to refresh Pivot Table.
>
> I cant find a way to edit the Pivot Table MS Query for the new SQL Columns
> Name like I can when just using MS Query to import data into excel vs into
> Pivot.
>
> Is this possible?
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't change Pivot Table data source AABob Microsoft Excel Worksheet Functions 2 13th Apr 2010 06:32 PM
Pivot table change data source mcarter Microsoft Excel Misc 1 15th Sep 2009 01:13 PM
change data source of pivot table =?Utf-8?B?Sm9obkg=?= Microsoft Excel Misc 9 15th Sep 2006 12:52 AM
How to change Pivot table data source? =?Utf-8?B?SnVsaWU=?= Microsoft Excel Worksheet Functions 0 11th Oct 2004 03:39 AM
Re: Change Pivot Table Data Source Debra Dalgleish Microsoft Excel Misc 0 21st Jun 2004 11:57 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:43 AM.