Changing DSN connection in Pivot table

[Guest]

I need to change the DSN connection in a pivottable that is not derived from a querytable.I have about 100 Pivottable to work on and thus would like to do it programmatically through codes rather than creating new pivottable from the begining.Pls help very urgent thanks

 

[Mark W.]

If you have XL2000 see if you can change it using the Microsoft Script Editor (Alt+Shift+F11). Warning -- experiment on a copy of your worksheet!!!
This message was edited by Mark W. on 2002-03-01 11:38