| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table accessing external data
Hello. In Excel 2003 I used to be able to create a pivot table that used a
query to access certain data in an SQL database. In 2007 I am not finding how to create such a pivot table. I find I can connect to a database or a table in a database but do not see how to draw from that table using a query. Am I missing something? Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error accessing external object property XVALUES | Excel Discussion (Misc queries) | |||
| Pivot Table Data Source external excel file | Excel Discussion (Misc queries) | |||
| external import of multiple worksheet data & create pivot table | Excel Worksheet Functions | |||
| Working With Pivot Table And External DB | Excel Discussion (Misc queries) | |||
| Pivot table using External data | Excel Discussion (Misc queries) | |||
Threaded Mode
