Pivot table source data question

  • Thread starter Thread starter MattShoreson
  • Start date Start date
M

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel / Sql Server / Pivot Tables 2
Unable to Group in Pivot Table 1
Pivot table multiple filters 2
Setting external data location for a pivot table 1
Dynamically refreshing Pivot Table Range. 3
How to build / refresh pivot table without ODBC?? 1
Expand and collapse 2
pivot refresh hangs 2

Back
Top