Pivot table source data question

[MattShoreson]

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.

 

[Tom Ogilvy]

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.