| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I disable Subtotals?
Hi,
Using another application I export reports to Excel. However, some of the reports appears in Excel with subtotals. I want to remove the subtotals. I know that I can remove them by going to Data SubTotals Remove all, but then I have to do this for every report I execute to Excel. Do anyone know about a way of disable Subtotals within Excel? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I disable Subtotals?
I don't completely follow you. If the reports already comes to you with
subtotals then you can not just de-activate them. They already exist. Automated subtotals are not a formating of the data but are a physical manipulation of the data. To get rid to the subtotals the spreadsheet must be physically manipulated back to it's original form. So I guess the answer is no. -- HTH... Jim Thomlinson "Becky" wrote: Hi, Using another application I export reports to Excel. However, some of the reports appears in Excel with subtotals. I want to remove the subtotals. I know that I can remove them by going to Data SubTotals Remove all, but then I have to do this for every report I execute to Excel. Do anyone know about a way of disable Subtotals within Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotals problem: Excel 2003 (not, AFAIK, the nested subtotals bug) | Excel Discussion (Misc queries) | |||
| Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
| How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
| Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
| disable Subtotals Outline Symbols | Excel Programming | |||
Linear Mode
