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/

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/