T
Terence C
Dear all,
I am building an excel report with pivot table and the data source is from
SQL server 2000. However, when I build the pivot table, it requires me to
provide an ODBC name on my computer. This report will be distributed to more
than 10 users and it would not be convenient if we have to set up the same
ODBC data source in each user's computer since they will refresh the data
themselves.
Therefore, is there any way to refresh the pivot without ODBC? Please advice
and thanks in advance!!
I am building an excel report with pivot table and the data source is from
SQL server 2000. However, when I build the pivot table, it requires me to
provide an ODBC name on my computer. This report will be distributed to more
than 10 users and it would not be convenient if we have to set up the same
ODBC data source in each user's computer since they will refresh the data
themselves.
Therefore, is there any way to refresh the pivot without ODBC? Please advice
and thanks in advance!!