MrExcel.com - Your One Stop for Excel Tips & Solutions

Using External data in pivot tables

Posted by Erwin Manlapaz on August 10, 2001 9:01 AM

My pivot tables are currently setup to access an external db. Is there a way that I can move the db to a new location and/or change the name of the db without having to redo my entire pivot table? In other words, how do I change where the pivot table is pointing to for its data?

Thanks.

Posted by Mark W. on August 10, 2001 9:05 AM

Aren't you using Microsoft's ODBC Administrator?

Posted by Erwin Manlapaz on August 10, 2001 9:11 AM

Mark,

I'm using Excel's Query Wizard which accesses the data via an ODBC connection. The problem is I've never played with the ODBC administrator and I don't want to screw something up. Is there a within the administrator to solve my dilemma? Thanks in advance.