| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotalling in Excel 2007
In Excel 2007 certain workbooks don't allow the Subtotal function in Outline
to be used. Why? What could be changed in the workbook/sheet to allow subtotals to be generated? Does data need to be a certain format? TIA |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotalling in Excel 2007
Are the worksheets protected?
Are the workbooks shared? Do you have more than one worksheet selected? Any of these would make the subtotal and outling unavailable. Gord Dibben MS Excel MVP On Wed, 6 May 2009 08:53:01 -0700, vtj wrote: In Excel 2007 certain workbooks don't allow the Subtotal function in Outline to be used. Why? What could be changed in the workbook/sheet to allow subtotals to be generated? Does data need to be a certain format? TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotalling | Excel Worksheet Functions | |||
| Subtotalling | New Users to Excel | |||
| Subtotalling | Excel Worksheet Functions | |||
| Subtotalling | Excel Worksheet Functions | |||
| Bolding when subtotalling | Excel Worksheet Functions | |||
Linear Mode
