| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel 2003 Subtotals not working correctly
Just upgraded to Office 2003 and I do a lot of subtotals and nested subtotals
for our various unit/division/subdivision/mananager reports. I had no problems at all with our pervious version but now I am unable to get the subtotals to nest correctly. Now I can create the nested report, but if I expand the report to see all the data, it then gets confused and won't summarize again. Anyone else having this issue? |
|
#2
|
|||
|
|||
|
maybe...
Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003 http://support.microsoft.com/default...b;en-us;831824 Mike Sattan wrote: Just upgraded to Office 2003 and I do a lot of subtotals and nested subtotals for our various unit/division/subdivision/mananager reports. I had no problems at all with our pervious version but now I am unable to get the subtotals to nest correctly. Now I can create the nested report, but if I expand the report to see all the data, it then gets confused and won't summarize again. Anyone else having this issue? -- Dave Peterson |
|
#3
|
|||
|
|||
|
Excellent! Thank you very much! With as much subtotaling as I do, I was
afraid I was going to be getting very frustrated. "Dave Peterson" wrote: maybe... Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003 http://support.microsoft.com/default...b;en-us;831824 Mike Sattan wrote: Just upgraded to Office 2003 and I do a lot of subtotals and nested subtotals for our various unit/division/subdivision/mananager reports. I had no problems at all with our pervious version but now I am unable to get the subtotals to nest correctly. Now I can create the nested report, but if I expand the report to see all the data, it then gets confused and won't summarize again. Anyone else having this issue? -- Dave Peterson |
|
#4
|
|||
|
|||
|
Excel 2003 Subtotals not working correctly
I was getting ready to reload 97 which IT would not like.
Thank you. "Dave Peterson" wrote: maybe... Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003 http://support.microsoft.com/default...b;en-us;831824 Mike Sattan wrote: Just upgraded to Office 2003 and I do a lot of subtotals and nested subtotals for our various unit/division/subdivision/mananager reports. I had no problems at all with our pervious version but now I am unable to get the subtotals to nest correctly. Now I can create the nested report, but if I expand the report to see all the data, it then gets confused and won't summarize again. Anyone else having this issue? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2003 Subtotals not working correctly
Awesome!! This fixed the nagging problem that I have been tripping over for
two or three years now. "Dave Peterson" wrote: maybe... Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003 http://support.microsoft.com/default...b;en-us;831824 Mike Sattan wrote: Just upgraded to Office 2003 and I do a lot of subtotals and nested subtotals for our various unit/division/subdivision/mananager reports. I had no problems at all with our pervious version but now I am unable to get the subtotals to nest correctly. Now I can create the nested report, but if I expand the report to see all the data, it then gets confused and won't summarize again. Anyone else having this issue? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with Excel 2003 restricting functionality | Excel Discussion (Misc queries) | |||
| Working with Lists in Excel 2003 | Excel Worksheet Functions | |||
| Nested Subtotals in Excel 2003 -Solution | Excel Discussion (Misc queries) | |||
| Excel 2003 V's Excel 2000? | Excel Worksheet Functions | |||
| sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
