Pivot table source data question
 

I have a pivot table using a stored proc on a sql server db.
I can repoint this pivot table to different stored procs on the same
ODBC DSN.
Is there any way to repoint the Pivot to a different DSN?
i.e. to use the same stored proc but on a different SQL db using a
different DSN?

Cheers in Advance.
Matt.


---
Message posted from http://www.ExcelForum.com/

Pivot table source data question
 

If you mean with code. Look at the connection and sql properties of the
pivotcache. Query the current value and then see how you would modify it to
redirect.

--
Regards,
Tom Ogilvy


"MattShoreson " wrote in
message ...
I have a pivot table using a stored proc on a sql server db.
I can repoint this pivot table to different stored procs on the same
ODBC DSN.
Is there any way to repoint the Pivot to a different DSN?
i.e. to use the same stored proc but on a different SQL db using a
different DSN?

Cheers in Advance.
Matt.


---
Message posted from http://www.ExcelForum.com/