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
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
DSN and Pivottable
- Thread starter matlori
- Start date
Excel Facts
Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Similar threads
- Replies
- 1
- Views
- 84
- Solved
- Replies
- 2
- Views
- 70
- Question
- Replies
- 0
- Views
- 424
- Replies
- 4
- Views
- 280
- Replies
- 0
- Views
- 195
