View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MattShoreson[_11_] MattShoreson[_11_] is offline
external usenet poster
 
Posts: 1
Default 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/