Thread: Setting CommandText property of PivotCache fails if cache has 1 PivotTable
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ashortxl[_2_] ashortxl[_2_] is offline
external usenet poster
  
Posts: 1
Default Setting CommandText property of PivotCache fails if cache has 1 PivotTable

I solved the problem. By default, the pivot table wizard / Quer
creates an ODBC connection. If I change the connection string to us
OLE DB instead of ODBC, then everything is fixed

--
ashortx
-----------------------------------------------------------------------
ashortxl's Profile: http://www.msusenet.com/member.php?userid=104
View this thread: http://www.msusenet.com/t-187041390

Reply With QuoteReply With Quote