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