subtotalling with summary values above
 

Hi,
I'm trying to nest automatic subtotals for three columns with the summary
totals above the data. (I'm creating my macro by recording the steps.)
However, when I create the second subtotal, the first total row inserts above
the total row for the first subtotal. I hope that makes sense.

It looks like this:

EARTH SYSTEM SCIENCE Total
EARTH SCIENCE Total
EARTH SCIENCE EARTH SYSTEM SCIENCE
EARTH SCIENCE EARTH SYSTEM SCIENCE

as opposed to:

EARTH SCIENCE Total
EARTH SYSTEM SCIENCE Total
EARTH SCIENCE EARTH SYSTEM SCIENCE
EARTH SCIENCE EARTH SYSTEM SCIENCE

It also messes up the expand + and - buttons aside from messing up my
totals. I've tried inserting the subtotals in different order and with
different columns selected, but nothing has helped. Oh, yeah. I just
upgraded to Office 2003....

Thanks for any assistance.

Nevermind... sorry for wasting time. I found the fix in the Knowledge Base...
required a registry change. Works great now!

Merry Christmas,
Leslie

"Leslie Miller" wrote:

Hi,
I'm trying to nest automatic subtotals for three columns with the summary
totals above the data. (I'm creating my macro by recording the steps.)
However, when I create the second subtotal, the first total row inserts above
the total row for the first subtotal. I hope that makes sense.

It looks like this:

EARTH SYSTEM SCIENCE Total
EARTH SCIENCE Total
EARTH SCIENCE EARTH SYSTEM SCIENCE
EARTH SCIENCE EARTH SYSTEM SCIENCE

as opposed to:

EARTH SCIENCE Total
EARTH SYSTEM SCIENCE Total
EARTH SCIENCE EARTH SYSTEM SCIENCE
EARTH SCIENCE EARTH SYSTEM SCIENCE

It also messes up the expand + and - buttons aside from messing up my
totals. I've tried inserting the subtotals in different order and with
different columns selected, but nothing has helped. Oh, yeah. I just
upgraded to Office 2003....

Thanks for any assistance.