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
Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Similar threads
- Replies
- 1
- Views
- 82
- Solved
- Replies
- 2
- Views
- 58
- Question
- Replies
- 0
- Views
- 422
- Replies
- 4
- Views
- 276
- Replies
- 0
- Views
- 191
