Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DBADave
Constraint Violating Yak Guru
366 Posts |
 Posted - 2005-05-26 : 12:32:53
|
| We are migrating to new servers and I need to change my pivot table (EXCEL 2002) report to reference the new servers. How can I do this?Thanks, Dave |
|
|
jbeil
Starting Member
1 Post |
Posted - 2005-06-22 : 17:59:47
|
| Right click on the pivot and launch the pivotchart wizard.Select 'back' and then 'get data'. It will connect to your current data source and bring up MS Query. Once loaded go to file, table definition. Select <New Data Source> then 'OK'. This brings up the create new data source dialogue box. Once done select 'ok'. Then ok, close and save it. Be sure to click on 'finish' once back @ the pivotchart wizard. |
 |
|
|
DBADave
Constraint Violating Yak Guru
366 Posts |
Posted - 2005-06-23 : 09:36:20
|
| Someone else suggested the same thing in another forum, however the BACK button is grayed out when I open the wizard. I'm using Excel 2002 SP2 if that makes any difference.Thanks, Dave |
|
|
|
pedro_11
Starting Member
1 Post |
Posted - 2005-07-05 : 12:09:24
|
| If you remove or rename the old data source Excel will allow you to select a new one when you attempt to refresh it as the refresh will fail. |
|
|
|
DBADave
Constraint Violating Yak Guru
366 Posts |
Posted - 2005-07-05 : 14:49:34
|
| Unfortunately I cannot see the old data sources. They do not appear in any DSNY lists. I eventually rebuilt the pivot tables.Thanks, Dave |
|
|
|
|
|
|
How to change Pivot Table data source?