View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ivan ivan is offline
external usenet poster
 
Posts: 67
Default Rrefesh pivot table without ODBC

Dear all,

I would like to build a pivot table in an Excel file and the source of data
is from a SQL view in SQL server, this file will be distributed different
users in the company. It would be troublesome if I create an ODBC entry in
each user's computer. So is there any way to skip the ODBC and the users can
refresh the pivot table? Thanks in advance.

Ivan