Excel Sub-Totaling not Compiling the Total Lines in Proper Order
 

I'm trying to place sub-totals throughout approx 6000 lines of data. Approx
1/2 way through the data, it starts to compile the totals incorrectly.

Example where I'm trying to total by Jacksonville / Sales & Marketing Dept /
Advertising-Media (It places the "total" for the advertising account OUTSIDE
of the grouping for the Sales & Marketing Dept) ...

Jacksonville Sales & Marketing Advertising-Media $
Sales & Marketing Total $$$$
Advertising-Media Total $$
Jacksonville Total $$$$$

I've done this at least 2 dozen times trying to confirm what is happening
and I do not know what it is ...

Thanks
Curt

Excel Sub-Totaling not Compiling the Total Lines in Proper Order
 

A registry entry may be needed to fix this problem. Follow these steps and
see if it helps:

1. Quit all Microsoft Office programs.
2. Click Start, and then click Run.
3. In the Open box, type regedit, and then click OK.
4. Locate and then click to select the following registry key:

Excel 2002
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\E xcel\Options
Excel 2003
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options
5. After you select the key that is specified in step 4, point to New
on the Edit menu, and then click DWORD value.
6. Type Excel97Subtotals, and then press ENTER.
7. Right-click Excel97Subtotals, and then click Modify.
8. In the Value data box, type 1, and then click OK.
9. On the File menu, click Exit to quit Registry Editor


--
Jim
"Curt-Merchants" wrote in message
...
| I'm trying to place sub-totals throughout approx 6000 lines of data.
Approx
| 1/2 way through the data, it starts to compile the totals incorrectly.
|
| Example where I'm trying to total by Jacksonville / Sales & Marketing Dept
/
| Advertising-Media (It places the "total" for the advertising account
OUTSIDE
| of the grouping for the Sales & Marketing Dept) ...
|
| Jacksonville Sales & Marketing Advertising-Media $
| Sales & Marketing Total $$$$
| Advertising-Media Total $$
| Jacksonville Total $$$$$
|
| I've done this at least 2 dozen times trying to confirm what is happening
| and I do not know what it is ...
|
| Thanks
| Curt
|
|