| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to build / refresh pivot table without ODBC??
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!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
| build a pivot table from multiple other pivot tables. | Excel Discussion (Misc queries) | |||
| Pivot Refresh over ODBC | Excel Programming | |||
| Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
| Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH | Excel Programming | |||
Threaded Mode
