View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GregR GregR is offline
external usenet poster
 
Posts: 246
Default Pivot Refresh over ODBC

Cinque, try this

"ODBC;DSN=XXX;Description=XXX;UID=userID;PWD=Passw ord;APP=Microsoft
Office 2003;WSID=XXX;DATABASE=Intranet;LANGUAGE=us_englis h
Supply your own parameters.

Greg