Changing DSN connection in Pivot table

Mar 1st, 2002, 09:28 AM

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. · Mar 1st, 2002, 12:37 PM

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 ]

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

Mar 1st, 2002, 09:28 AM	#1
Guest Posts: n/a	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

Mar 1st, 2002, 12:37 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	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 ]