| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert subtotal in a query database Excel 2007
After querying a database and importing the results in an Excel 2007
worksheet, I am unable to use the subtotal command in the Outline Group of the Data tab. I could do this in Excel 2003, but after the upgrade I no longer can do this and at the same time keep the query connection to the database so I can refresh the data. How can I accomplish keeping my data live (connected to the external database via Microsoft Query) and at the same time insert subtotals using the sub total command in the Outline Group under the Data tab? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| database query not showing foxpro database How I import data | New Users to Excel | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
| Excel Database Query | Setting up and Configuration of Excel | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Threaded Mode
