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.