Rrefesh pivot table without ODBC

I

Ivan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to build / refresh pivot table without ODBC?? 1
Pivot table drill down sort 0
Doughnut Chart linked with the slicer in the pivot table 0
Excel does not accept text format! 0
Pivot table 0
Pass a command text in pivot table 0
How to modify the sql statement on a pivot table using VBA- XL2000 1
Pivot Table Question 2

Top