how to change connection for excel pivot table report?

#1

for example i like to change role or server name for excel's pivot table.

how can i do that.

obvious solution

objPivotTable.PivotCache.Connection = sConnectionString

doesnt work

#2

hehe, solved. i was so blind.
need a rest probably... yep.

"Alexander Nenashev" <nenashev (AT) hotbox (DOT) ru> wrote

Quote:

for example i like to change role or server name for excel's pivot table.

how can i do that.

obvious solution

objPivotTable.PivotCache.Connection = sConnectionString

doesnt work

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

how to change connection for excel pivot table report?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

how to change connection for excel pivot table report? - 07-19-2004 , 02:43 AM

Re: how to change connection for excel pivot table report? - 08-16-2004 , 09:21 PM